Posted by just.an.imbecile on 09/30/27 11:45

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.

• Next in forum: Re: SQL-DMO and C#: retrieve the list of User-Defined Functions
• Prev in forum: Re: SQL Svr 2005 Express Does NOT Support DTS
• Thread view: Re: Re-display result set without re-running query in Query Analyzer?

[Reply to this message]