At this point I am not sure if I am better off using dynamic sql or using optional parameters in my t-sql script. Any thoughts?

Thanks

I came up with a different solution that I am close to fixing, but am having a problem with. I decided to use an IN clause so that my...

Thanks. I have decided to take your advice and go with Dynamic SQL as in this case it is much cleaner and easy to maintain. If I hit a...

I tried to get the case statement to work, but I could not get the sort Descending to compile no matter what I tried. I came across this article...

Thanks. I was hoping for an easier way to make these types of changes, but I guess I am stuck with what I am currently doing or using dynamic sql.

Thanks for the suggestion. That is basically what I am doing.

I had initially thought that using a CTE would work. I tried the following but could not...

Unfortunately for me the tables do tend to change more then I would like (this is out of my control).

I agree that I could use Sergiy's method for the...

Thanks for the fast response.

This sounds like a good plan.

Thanks

I have not heard of Toad for SQL Server. I am going to have to look into this as well as the all of the other suggestions.

Based on the...

Thanks. I was not aware of that option.

Thanks very much for the clear and well thought out response.

I was not sure if there was a way to keep the identity fields in synch from database to database. I will use a Backup and Restore.

Thanks

Thanks to the both of you. I came up with a similar approach on my own, but I like yours better.

Thanks again.

First I would like to thank you for getting back to me. I was about to give up on this post.

While I like your approach I have...