Need some help

Results 1 to 2 of 2

Thread: Need some help

  1. #1
    Join Date
    Dec 1969

    Default Need some help

    How would you write a DELETE DISTINCTROW statement to delete a record in a database table where 2 fields are blank and the current server time is the current server time minus 1 hour?<BR><BR>Thank you!

  2. #2 Guest

    Default RE: Need some help

    Delete from YourTable where field1 is null and field2 is null and datediff("h",now(),YourTimeField) &#062; 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts