locked
execute part of the where clause every end month RRS feed

  • Question

  • hello everyone,
    i'm here and i have a question. I need to make part of my select statement execute dailly where the proc is executed and the other part once every end month. Both statements are at the where clause as shown below....

    WHERE

     

    T.ChargeGroup_ID IN (18,19,24,25,26,27,22,28,29,34)
    OR (T.ChargeGroup_ID IN(21,30,31,32,33) AND @Date = (select dateadd(dd, -day(dateadd(m,1,@date)),dateadd(m,1,@date)) )

     

    )

    Tuesday, November 3, 2009 3:42 PM

Answers