Home Forums SQL Server 2005 T-SQL (SS2K5) Trying to fire this off, but only if there are results... RE: Trying to fire this off, but only if there are results...

  • May 21, 2013 at 7:00 am

    #1616980

    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

    --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!