I just need a query in SQL for the following: Create a heading of REPORTING STATEMENTS as a comment at the bottom of your script file – A list of the programs on all channels for a specific day showing the channel number, supplier, package, program name, rating code, and show time. This will be similar to a program guide, only not package specific. This is a date-driven report, therefore it should only display programs for a single date specified.
I have attached what I have so far.