Dynamic Select Statement

[sqlserverbest]

How do print the value of variable @totsum


declare @totsum money, @sql varchar(1000)
set @sql = 'select @totsum = sum(price) from product'
execute(@sql)

print str(@totsum,15,2)

I am getting the message as @totsum not declared.

Your help is appreciated.

 

[SonOfEmidec1100]

Have a look at tbroadbents response to thread183-449585 SQL working backwards


cjw

 

[sqlserverbest]

That me again!!!

I tried this code making it much simpler and it said I much declare @rowcount variable when it is already declared.

DECLARE @sql varchar(1000), @rowccount int
SET @sql = 'Select @rc=count(*) From ttg_position_stg'
EXECUTE sp_executesql @sql, N'@rc int output', @rc=@rowcount output

Help is appreciated

 

[TheBugSlayer]

Try this simpler form:

declare @totsum money
select @totsum = sum(price) from product
print @totsum

Format as you please.


Hope this helps...