Here is my two cents. Don't use it. It is not a guarantee that it will identify all changes to your data. It is possible for a...

andymackk (8/25/2009)

---

would it be possible for you to show me how to put the results into a permanent table?

I tried , and it created a table, but it isn't the...

The way I look at it is, the criteria for joining the tables belongs in the ON statement in the FROM CLAUSE and the filter criteria for the result set...

Since this is in a SQL Server 2005 forum something else to consider as well. Go ahead and create the views in the other database and grant access to...

andymackk (8/25/2009)

---

Lynn,

I have gone with your original code (attached again)because:

1) the Timestamp is always in date order, so that would appear to be ok

2) There is less code and...

Jeff Moden (8/12/2009)

---

Thanks for the help, Joe. I appreciate the time.

The answers would be "no, nothing like that going on" to 1, "did both before and yes, same problem"...

Please do not make multiple post for the same request. It simply fragments and potentially duplicates answers you may receive. Please post any replies here.

Please do not make multiple post for the same request. It simply fragments and potentially duplicates answers you may receive. Please post any replies here.

Please do not make multiple post for the same request. It simply fragments and potentially duplicates answers you may receive. Please post any replies here.

Been there, done that, got the t-shirt. 😉

You probably got a concussion from banging your head on your keyboard too many times. 😛

Actually, Mitch, Matt and I are asking for the same thing. Thank you for your existing code, but we still need the DDL for the table(s), sample data, and...