fixthebug2003
Programmer
Hi,
I have a dynamically built SQL String in my Stored Procedure.
To execure it I use
EXEC(@v_sql_String)
The v_sql_string is a SELECT statement that returns a count [select count(*) from table1 where...]
is it not possible to get this count into a variable in the stored Procedure like this
SELECT @v_count=EXEC(@v_sql_String)
if yes let me know the exact syntax.
Thanks,
Fixthebug2003
I have a dynamically built SQL String in my Stored Procedure.
To execure it I use
EXEC(@v_sql_String)
The v_sql_string is a SELECT statement that returns a count [select count(*) from table1 where...]
is it not possible to get this count into a variable in the stored Procedure like this
SELECT @v_count=EXEC(@v_sql_String)
if yes let me know the exact syntax.
Thanks,
Fixthebug2003