SwePeso (7/20/2013)
Why not use the OUTPUT clause?
Output clause works can output the data to the screen or to a table. It can't output the data into a variable. Since in this case I will always get only 1 column and only 1 record, I don't want to use temporary tables.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/