May 21, 2013 at 6:54 am
Hi,
I'm using this bit of code to email results, but only if there are results/records:
IF select count(*) from (Select deddedcode as "DED CODE", dedlongDesc as DESCRIPTION, deddatetimecreated as DATE from dedcode where deddatetimecreated > DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), -55) > 0
begin
Get seem to figure out the syntax..
May 21, 2013 at 7:00 am
i think using EXISTS is a little better, and is what I would typically do:
--does ANY data match the criteria?
IF EXISTS (SELECT
1
FROM dedcode
WHERE deddatetimecreated > DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), -55)
)
BEGIN
--build a report with this data?
SELECT
deddedcode AS "DED CODE",
dedlongDesc AS DESCRIPTION,
deddatetimecreated AS DATE
FROM dedcode WHERE deddatetimecreated > DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), -55)
END
Lowell
May 21, 2013 at 7:08 am
Perfect!
Thanks Lowell. You are the man.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply