Posted by Erland Sommarskog on 04/09/06 22:33

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Difference between multiple primary and secondary files..
• Prev in forum: Re: Disk or network error
• Thread view: Re: Re-display result set without re-running query in Query Analyzer?

[Reply to this message]