Well, the CrossTab solution I used is based on one of Jeff's articles as well...

Let's see, which one is going to...

Is there any predefined order the data have to show up in the columns?

Based on your sample data it looks like the following would help (as a second step to...

Untested, since there are no data provided to test against:

;with cte as

(

select UserID

from table

group by UserID

having count(*) >1

)

select table.* from table inner join cte on cte.UserID = table.UserID

You might think about using a calendar table.

Search this site for details.

An example can be found for instance here .

You could also have a look at the link in...

Just for the record of it:

the solution shahid posted has been provided by ramireddy at social.msdn .

Would you mind sharing some more details regarding the file structure and if those files are located in the same folder or have a "patterned" file name?

Also, would you share...

Something along those lines?

Note: The CASE statement is used to set a "flag" depending on the mode and then simply adding the "Flags"...

SELECT T1.ItemName, COUNT(T1.ItemName) AS TOTAL,

sum(case WHEN Mode='AAA' THEN...

Does "a column" means ONE column including the comma separated list?

If you need the data in a table with each value in its own column then please have a look...

Do you need the output o be one column each or a list of comma separated values?

This will take several steps:

Step 1: convert the string into a table

Step 2: separate the value of the first item

Step 3: Build a cross tab (see the related link in...

To get the columns and the corresponding values you could use the following code (using XQuery and your sample data):

DECLARE @in_values xml

SET @in_values = '<root><column_name><node_a>value1</node_a><node_b>value2</node_b></column_name></root>'

SELECT DISTINCT

T.n.value('localname[1]', 'varchar(100)')...

To even confuse a little more, 010409 might be as well interpreted as April 9th 2001...

I probably would even include the format in the string and truncate it where needed...

TcW_1978 (1/7/2010)

---

but I can't know if the field node_c needs to be updated to null or if the node_c doesn't exist in my xml string...

Is there a way I...

What xml element/attribute describes the column name?

Your examle is only using data from a column. There is nothing indicating any relationship between node_a and localname, meaning: How do you know...

It's hard to tell without sample data.

Please provide table def, sample data to play with and expected results as described in the first link in my signature.