Home Forums SQL Server 2005 T-SQL (SS2K5) Email script RE: Email script

  • September 24, 2009 at 9:38 am

    #1058118

    i know it's kind of repetitive, but htis is how i've done it...use an exists to test for the condition, then the query to build the email, same as you've done:

    IF EXISTS(SELECT 1

    FROM RT_MCP_Historic_Alarms

    WHERE [RT_MCP_Date_Time] >= Convert(char(10), DateADD(DAY, -1, GETDATE()), 101)

    AND [RT_MCP_Date_Time] 0

    GROUP BY RT_MCP_Name, RT_MCP_State, RT_MCP_Alarm_Text, RT_MCP_Bit_State, CONVERT(char(10), RT_MCP_Date_Time, 111)

    HAVING COUNT(RT_MCP_Alarm_Text) >= 30 )

    BEGIN

    --paste your commands here

    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!