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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by DirtyHairy
-
SQL join
Thanks for the reply. After staring at it for a while I actually just built some temporary tables and used a series of simple queries to put the data into a table, and then selected everything from that final table to display. The report time is now about 11 seconds, 4 or 5 of which are the...- DirtyHairy
- Post #3
- Forum: ANSI_SQL
-
SQL join
Hello, I am trying to run this on SQL Server 2000. I have 5 tables set up with these fields, in addition to others: table ug -------- ugid table u ------- uid fname lname table s ------- uid cid total_score completed counter table uga --------- ugid uid table ugl --------- ugid uid...- DirtyHairy
- Thread
- Replies: 2
- Forum: ANSI_SQL
