Retrieve the value from Dynamic Sql

[NET India]

Hello Friends, I've a dynamic sql and it's returning Max(TRN_AMOUNT) now i've to store this Max(TRN_AMOUNT) in a variable i.e. @NUM. Here is my code DECLARE @STRSQL VARCHAR(MAX),@NUM VARCHAR(MAX) SET @STRSQL='SELECT MAX(TRN_AMOUNT) FROM TRN' EXEC(@STRSQL) PRINT @NUM

[dan sh]

You can use following:

SET @STRSQL='SELECT @someVariable = MAX(TRN_AMOUNT) FROM TRN

You can declare @someVariable in your SP. BTW there is no need to dynamic query in the scenario you have mentioned.