Posted by Doug on 04/10/06 20:37

first time through select into a temp table.

then you can play with the temp table without having to go back to main
query.

• Next in forum: Remove Duplicate Rows
• Prev in forum: Re: SQL Server 2005: Collation Conflict Error when selecting Database Properties
• Thread view: Re: Re-display result set without re-running query in Query Analyzer?

[Reply to this message]