Trying to fire this off, but only if there are results...

  • 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..

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

  • 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