Output

[jonhbt]

If I have the following code Exec('Select Count(*) From table') how can I put the value of the execution into an integer type variable

[scottgp]

I honestly didn't know either, but a quick search found http://www.sqlteam.com/article/return-recordsets-from-dynamic-queries-called-by-exec[^] and http://www.sommarskog.se/dynamic_sql.html[^]. The second article looks very complete, and it looks like you might want to check out sp_executesql. Scott

[Kevin Horgan]

Hi, If you just what to store the COUNT value in a variable (@a) you could do this. declare @a int select @a = (SELECT COUNT(*) FROM table) Now select the count value from the variable... select @a