billybarty
Technical User
I have a bunch of SQL statements that query the software products we have to monitor. When putting the statements into an SMS 2003 Report there is a limit to how many lines or characters the query can be. Because of this I have had to creat 3 queries that list the software we want to track. I've been told I can creat a view in SQL that would return the results I want with all these statements and then have SMS query the view that I created. That way I can put all the software titles in the same report. Is this possible? I have looked on the web on how to creat a view but am not getting it and I wouldn't know how to write the query that would call on the view. Any help is appreciated.