If you had the following two rows, which value would you select for Col4, and why?

(1,2,3,4), (1,2,3,5)

Add a data conversion component between source and destination to change the datatype of Symbol as required.

Some observations:

1. You have written a load of text without asking for anything.
2. This looks like homework. For example, no one would ever key a table on 'first name' in...

I'd be interested to hear how long the new version takes.

I have not opened that attachment. Rather than 'JOIN' it sounds more like you want to concatenate.

Look up the CONCAT() function. It will help you with this.

If everything about the SELECT is static other than this 'value', you may be able to create a table-valued function (link) for them.

My suggestion is to look again. I just searched for this and found such a script on my first attempt. Remember, XML files are just text files.

Have you looked at the Execution Plans?

• This reply was modified 2 years, 10 months ago by Phil Parkin.
• This reply was modified 2 years, 10 months ago by Phil Parkin.

Is there any possibility of educating the person maintaining the table in the ways of normalisation? Just add a date column to TableB and the need for fancy querying of...

It is possible and straightforward to reset the IDENTITY property of a column after deleting rows in its table. Would that solve your problem?

• This reply was modified 2 years, 10 months ago by Phil Parkin.

Does the number of columns vary, depending on the number of items in the order?

If you would like a coded solution, please present your sample data in the form of CREATE TABLE/INSERT statements.

I've seen that behaviour too.

This could start a flame war! I've seen instances of otherwise-seasoned coders on here using the dreaded

;WITH CTE AS...

So, I could use some help on this one: To Drop or Not to Drop (the temp table question) – SQLServerCentral Forums

I've tried Googling it but not finding...