I have written a SQL report that validates many of our tables. Only when there is an error on a table will a report of that table print. The script contains 32 different select statements each one associated with a different table. I need to have a page break between the reports because the tables are maintained by different people. I am trying to do 2 things. 1 - eliminate an initial page break which is producing a blank page. The 2nd thing I wanted to do was force the first page to say 'THIS IS THE START OF THE ERROR REPORTS'. I've tried many ways but it never prints this statement on a page by itself. Actually, it never prints at all.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!