如何使用sql添加3个exec结果..？ [英] How to add 3 exec result using sql..?

问题描述

DECLARE @sql    NVARCHAR(MAX),
        @CompID NVARCHAR(MAX),
        @ID     NVARCHAR(MAX);
SET @CompID = 245;
SET @sql = 'SELECT SUM(Cw.Weightage) AS CompanyWeight FROM CompanyWeight CW WHERE CW.CompanyID IN (' + @CompID + ')';
SET @sql = @sql + ' SELECT SUM(LW.LocWeight) AS LocWeight FROM LocationWeight LW WHERE LW.CompanyID IN (' + @CompID + ')';
SET @sql = @sql + ' SELECT SUM(CPW.Weight) AS ContWeight FROM ContactPersonWeight CPW WHERE CPW.CompanyID IN (' + @CompID + ')';
EXEC ( @sql );

我尝试了什么：



我试图添加以下Exec结果.. ..当结果出现在select1 result = 30，select2 result = 20和select3 result = 25时，我不知道如何添加..



我需要输出30 + 20 + 25 = 75



请帮助... SQL

What I have tried:

I m trying to add the below Exec result ....I don't know how to add when the result came on select1 result =30 , select2 result =20 and select3 result =25..

I need output for 30+20+25 = 75

plz kindly help...SQL

推荐答案

SELECT (SELECT SUM(Cw.Weightage) AS CompanyWeight FROM CompanyWeight CW WHERE CW.CompanyID IN (@CompID )) + (SELECT SUM(LW.LocWeight) AS LocWeight FROM LocationWeight LW WHERE LW.CompanyID IN (@CompID ))+ (SELECT SUM(CPW.Weight) AS ContWeight FROM ContactPersonWeight CPW WHERE CPW.CompanyID IN ( @CompID))

试试这个！



[Edit-karthik]：在代码块中添加。

try this!

: added in code block.

这篇关于如何使用sql添加3个exec结果..？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！