var from query

[dupa12345]

can i do something like this somehow?

declare x float;
set x = select count(*) from t1;

i want to use x as a row count in several places in following queries in my procedure.

thx all for your previous responses!!!

 

[tdsmart]

Your select statement in the procedure should be something like :

select count(*) into :x from t1;