locked
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

  • Please help me ... :X
    Saturday, June 5, 2010 3:21 PM
  • Could you post the exact error? Also, what environment are you using to run this SQL statement?
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Saturday, June 5, 2010 4:07 PM
  • Hello Paul ,

    QN no send any Error ...

    it's only send invalid Statment ...

    thanks ..

    Saturday, June 5, 2010 5:11 PM
  • No nobody help me?
    Sunday, June 6, 2010 4:53 PM
  • The syntax looks OK but I don't really know much about Query Notification. Have you tried hard-coding values to see if you can get the statement to execute? It's possible that certain expressions or functions are not allowed for Query Notification.
    Paul ~~~~ Microsoft MVP (Visual Basic)
    Tuesday, June 8, 2010 12:53 PM