That doesn't quite work either. I tried that in the earlier post (the "variation"). I've found other Cases which should be included in my resultset but aren't. ...

It did take me a minute to get it, with the NULL for drv table, (looking at it the opposite way that i was, why didn't I think of that??)...

Oh Craig, this is so close. I may not necessarily understand it right off the bat, but it looks so close.

I had to add two more specifications to narrow...

This query came back to haunt me. Of course the last variation didn't do exactly what I needed it to so now it's the monkey on my back again...

I...

Thanks for the responses. Let's see if I can clarify a few things...

I'm the one who set up the log shipping, based on what I've read and been told,...

Thank you Vedran. This did indeed help, immensely. Although I still got it to work with the LEFT JOINs as well, as long as I had the aliases right.

Thanks...

Hey thank you Jeff. I really appreciate your help on this, and it's exactly the CASE statement that I was looking for assistance with so thank you again...

On the last...

Vedran brings up a term that I hadn't considered: REPLACE. Since, as it was pointed out, I'm not necessarily adding new information, just replacing a value with another existing...

Thanks for the replies.

I'm a little nervous on the MERGE code since I'm not familiar with it. Can i assume that, while not best practice, the UPDATE FROM is...

Excellent Steve! Thanks so much! I did end up getting it. Turns out there's something odd going on in the software because it did indeed duplicate the legID (one...

Please forgive, I'm a bit of a novice at this...Is this kind of what you were talking about? (in a round about way?)

SELECT ba.FareTypeId

, ba.legid

, ba.PassType

, ba.SpaceType

INTO #temp

FROM...

Thank you for the confirmation, Derick! Makes this process a bit easier then!

Thank you, Wayne. I do have a test server (two actually) that I can play around with so I'll definitely be using those to see how it works out....

Ok, so I feel a little dense not realizing SQL already gives you two instances to restore to. Thanks for the reply. I'm a little nervous to set...

OoomBoom, our issue turned out to be memory related. The server wasn't recognizing all of the memory installed so there was lots of contention between the OS and SQL...