I have this little query:
Select deddedcode, dedlongDesc, deddatetimecreated from dedcode where deddatetimecreated > DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), -1)
I would like the results emailed to one person, but only if there are results (some days there won't be any new codes).
What's the easiest way to accomplish this?
It doesn't need to be a fancy report, plain text is fine.