When I used it, there was an Error if the @column_names = 0. The word VALUES would concatenate at the end of the table name without a space(i.e. INSERT...

Chris

Thanks for the idea. I see where you are going. The data structure that I have is a little different than what you have but it is similar...

--Here is some test data to help explain what I'm trying to do.

--create some sample data

CREATE TABLE #route (routeId int, priority int, destination int)

CREATE TABLE #routeData(routeDataId int, routeId int, itemname...

I guess that I wasn't very clear in my description of the problem but you figured it out! 🙂

I guess my main question is:

Is it possible to update the source...

This has turned into a very interesting discussion. One project that I did controlled the physical files via NT security and managed the links in the DB. The interesting...

Robert, thanks for the idea. I played with it and it works, I just don't understand how! Looking at the results, you would think that if the CASE...

Thank you for your suggestions. I will use the CASE in the order by and then I will have two options - one for ASC and one for DESC.

Thank you...

Thank you. That is what I was missing. I kept fooling with the list I was sending as @ClientList to see how I could get it converted correctly. Since this...