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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SMS Web Reports - Use of temporary tables
Okay, I've got it working. The "SET NOCOUNT ON" takes care of the display problem, where it was showing two empty recordsets where I had created the temp tables. Once I had done that I got an error for my third table (not sure why it didn't show before), and it had to do with a join to a view...- 98VFR
- Post #4
- Forum: Microsoft: SMS (Systems Management Server)
-
SMS Web Reports - Use of temporary tables
Hi all! I'm trying to figure out how to use temporary tables from within SMS 2003 Reporting. I can do it directly in SQL, such as through Query Analyzer, but when I use the same SQL statements in my web report, it doesn't work. Here's the basic structure of my statement...- 98VFR
- Thread
- Replies: 4
- Forum: Microsoft: SMS (Systems Management Server)
