General information
Forum:
Microsoft SQL Server
>Do you want a clue or the answer? The clue is in rewording the problem:
>
>I want the first record that comes before the current audit record for the same ID.
>
>-Mike
Right, and I have been able to write a query to get the audit_id of the record that comes before a specific audit_id record, but I am not sure how to write it to return a rs that meets a certain date range. I'd hate to resort to a cursor.
So, I guess I want the answer.
BOb
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only