Query Notification Support DATEDIFF ? RRS feed

  • Question

  • Hello ,

     I use the Query notification I run this Query:
    Select ID_Key From dbo.TableName where DATEDIFF (ss, GETDATE (), dbo.tablename.DateX) <0

    But give me the error invalid.
    How I can I do this?
    Is there a way?

    Thanks ....

    • Moved by Pawel Marciniak Friday, June 4, 2010 4:06 PM (From:SQL Service Broker)
    Thursday, June 3, 2010 9:25 PM

All replies