I'll get back to you more this evening if I can. Have things I need to do right now. If not tonight, definately tomorrow evening.

sjsubscribe (8/25/2009)

---

This has been a perpetual problem for govt employment. For some jobs we could not even acknowledge product familiarity much less evaluate or offer critical advice. So most of...

This is the only part I don't agree with and I think there are many...

Gus, are (did) you use CHECKSUM or BINARY_CHECKSUM? If I was going this direction, I would look at the later. Of course, I don't have the volume of...

cjohn5552 (8/25/2009)

---

Hello all,

A colleague of mine showed me a query employing some methods of controlling query flow that I am not familiar with--in particular, the usage of...

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.