Along the same lines... but different.
In my quest for scheduling options, I have almost gotten to what I need... but I want to determine if a dataset that is returned from a SQL query is empty.
For instance, checking to see if today's date is stored in the database, like so:
select * from tblclosedDays where datePart(m,closedDay) = $Month$ and datepart(d,closedDay) = $Day$ and datepart(yyyy,closedDay) = $Year$
That works fine... but I need to then know did I get a resultant dataset or no results returned. |