just.an.imbecile (johntarr@gmail.com) writes:
> I appreciate the advice on @@rowset and I will be sure to set it to a
> variable. The problem is that quite often there are multiple rows
> returned, so I am forced to either re-run the query (which I don't want
> to do because it may bog down the DB). Or I could select into a temp
> table, but again I am concerned about a performance hit.

If your main concern is to keep down the load, then just skip extras
with the 'n/a' stuff, and just run the SELECT right away.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx