I think I figured it out, I just took the "BETWEEN" out and that seems to have resolved the issue. Thanks for your help; much appreciated!

Thanks for the quick response. MyAuditDate is a datetime.

I understand your logic, makes perfect sense. I tried your syntax above, but it doesn't like the "BETWEEN" (boldfaced below), it says...

Disregard my question; I've figured it out.

Jeff:

It's for auditing purposes. We want to be able to query a specific timespan and generate a report on the values that changed. So, in my example above, I want...

Thanks for the reply Jeff. I will read those articles; I appreciate the advice.

Awesome! Thank you....that has me well on my way to my final goal.

One final question; if I connect to my DB  and open SSMS using my own credentials, when I...

Thanks for the replies. Scott, when I tried your solution with my actual code below, it didn't like the portion "AS data(InvoiceNumber, InvoiceStatus, Timestamp"; it gave me a syntax error...

Thanks very much for both of your responses. I didn't take performance into account, but NBSteve gave me some good insight.

Thanks again!

Thanks so much for all of your responses; very much appreciated!