General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Fastest method for union of two selects
Environment versions
SQL Server:
SQL Server 2000
I have two select statements which calculate daily in - out qty for given item from transaction file.
As there is a sum() in the select the union is not working.
I had to achive this using the temporary table. The process is slow. Is there any other way to achive this.
Rajesh
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only