I have a database for my support guys and it will show the date opened and the date closed. What I want is a query that will return all of todays closed items, for the past seven days. This is how it is at the moment.
What I suppose my question is how do I run all "n" SQL statements and get them into a readable form most efficiently???
Code:
select * from support where dateclosed = getdate()What I suppose my question is how do I run all "n" SQL statements and get them into a readable form most efficiently???