Thank You Sir,
You are correct, this is very close. I was trying to take it one small step at a time. I think by doing that, it bit me....

Lynn,
Then how about the number of products sold per hour. I have listed everything that I can figure in the body of the post.

Andrew SQLDBA

Have you performed a count and that same WHERE clause in a query?

That will tell you exactly how many rows have that ID. Or is there a unique...

Thank You both for the very fast response and the examples.

I greatly appreciate it.

Andrew SQLDBA

Daniel

That is perfect.

Thank You so very much for your help with this. I was not thinking or trying anything that simple. Greatly appreciate it.

Thanks again

Andrew SQLDBA

Thank You Very much.

That is exactly what I needed. I was not even close in my code.

Thanks again

Andrew SQLDBA

Thank You to you both. That code worked very nicely. I had to change it just slightly, but you got me going down the correct path

Thank you again

Andrew SQLDBA

Thank You

Seems that is exactly what has happened. Someone changed the underlying table(s) that makes the View. I forgot about sp_refeshview.

Thanks again, and happy friday

Andrew SQLDBA

What about inserting all the rows into the ETL table that I have already verified, and then delete the rows from the ETL table that are already in the Destination...

Thank You to each and every one of you guys for your suggestions. Sorry I was not able to give more details and some examples. I know that is tough...

Thank you Everyone

I was actually trying to do this the long roud about hard way. I did not think about using Char() number, I was trying to actually use the...

Thank You

I knew there had to be a way. I should have checked sp_Configure before asking. Time for more coffee 🙂

Andrew SQLDBA

Thank You John

That is what I tried using a CTE, but I am not getting something correct. I am having trouble with select the correct row to delete.

Would you offer...

Thanks Everyone

Greatly appreciate all the great code samples, and suggestions

I did not any luck with the ISNUMERIC, I tried that first.

Andrew SQLDBA

Thanks

I have already tried that.

Andrew SQLDBA