Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: paulstrovsky
- Content: Threads
- Order by date
-
Combine results sets for loop without using TempTable
Hi all, I have a query that loops through weeks in order to sum up hours worked by employees. Everything works fine, except I get multiple result sets if I do this query without using a temp table. I figure there must be some way to work the UNION operator in at the beginning of the loop so...- paulstrovsky
- Thread
- Replies: 5
- Forum: ANSI_SQL
