i think using EXISTS is a little better, and is what I would typically do:
--does ANY data match the criteria?
IF EXISTS (SELECT
WHERE deddatetimecreated > DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), -55)
--build a report with this data?
deddedcode AS "DED CODE",
dedlongDesc AS DESCRIPTION,
deddatetimecreated AS DATE
FROM dedcode WHERE deddatetimecreated > DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), -55)
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!