Post reply

Query analyser not returning rows??

  • June 1, 2005 at 4:31 am

    #67528

    Can somebody help me out on this.

    I've been using query analyser for some time now with no problems, but over the last few days its been playing up. 

    When i execute a query that should bring back data it doesnt, but if i repeatedly press F5 or the execute icon - it does eventually.  Then doesnt, then does etc etc...you get the drift.    

    I'm the only user using the DB and have full SU rights.   Whats going on??

     

  • June 1, 2005 at 5:47 am

    #562134

    Sorry - sussed it.   I was using the following within my query:

    and isnull(e.enddate,GETDATE()) >= GETDATE()

    I'm guessing the value returned by getdate() sometimes changes between the two uses and so no data was being returned, but when was less activity on the server and it ran quick enough there was no difference and it returned my data.  Now changed to:

    and isnull(e.enddate,GETDATE()) >= convert(datetime,'01-jun-2005')

    which is sufficient.

     

    Thanks anyway.

    Paul.

     

     

  • June 1, 2005 at 8:14 am

    #562200

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply