Oh right! Duh!

Thanks

Thanks for the response SSCertifiable. The order by also needs to choose the greater of AddDt & UpdateDt. I'll definitely try and get the nullability squared away.

Only if there's a bug in the code.

Thanks Alan.B. Completely understood. I believe the real schema has the proper keys/indexes, I was just looking for the best query solution for this scenario. I will double check though.

Interesting solution LinksUp. Thank you. I'll try this in the real data and see how it goes. The real data is pretty large, eliminating a table scan should be pretty...

Awesome, thanks. I have great respect for your reputation Jeff. I've followed your posts for many years, and have tried to live my SQL Server life according to the principles...

Hi Jeff, thanks for the reply. I'll work on tracking down those specifics for you by tomorrow. What I can tell you so far is that the files are "positional",...

Thank you. Sounds reasonable. I'll give this a shot.

Thanks all for the great advice. Rewriting the sproc is not an option at this time. Since this is just a wrapper around the real work horse, I guess it's...

I think I figured out the problem. I was using the SQL 2012 SSMS to do the restore. On this version, the Restore Dialog has a new "Files" option on...

Quite right Crazy8! Getting my Visual Studios & SQLs all mixed up, which should not surprise you since Microsoft seems to be doing the same thing! Have you seen SSDT....

Yea I'm sold on that approach. I'm headed down that road now.

You are absolutely right about those things Jeff, I've not been giving those the attention they deserve.

Thanks

Good point dwain.

Perfect. Thank you Tom. Exactly what I am looking for.