Glad you could use it. Unfortunately, I had to come up with it on my own because nothing else I found worked the way I needed it to. It was...

I never did post my solution so here it is. Again, this was an attempt to do this with a single select statement. It uses CTEs much like you would...

Thanks for that suggestion amenjonathan. What you mention is precisely what we are doing. We are bringing in a copy of the production source tables to a staging server and...

We have been working on a new data warehouse and I thought the MERGE command was going to be a real game changer for us. I did some initial testing...

Thanks, I'll take a look at that. I seem to have found a solution using a series of CTEs that build upon each other. I did it by identifying the...

I don't know if this is an option for you or not, but you can also use a "select into" and that is not logged. We do that with some...

You know, for some reason that whole "boss" thing carries more weight than my opinion does! 😉

Just kidding, he actually is very good at listening to us because he is...

OK, I've read through tons of comments here that amount to nothing more than opinions regarding syntax and have seen very little that answers the real question aside from the...