Glad I could help 🙂

When learning XQuery you should consider looking into the great series of articles by Jacob Sebastian on this site. Search for "XML Workshop".

His series covers a...

I'm not sure how openxml can handle typed xml date (meaning xml data using namespaces).

However, since you're using SS2K5 or above I strongly recommend to look into XQuery. It is...

I don't recommend dsdeming's solution since it will set all other values for column USER_ORDER_QTY to NULL that don't match the CASE condition!!

@dsdeming: you might want to change the code...

Look for ROW_NUMBER() in BOL (BooksOnLine, the help system usually installed together with SQL Server).

It requires an column for sorting. So you have to think what would be the definition...

Ok, now it makes sense...

Would have helped a lot if the statement

had SQL tags around (maybe even with expected output) to look like

SELECT 1,2,3,4,5,6

/* result set

(No column name)(No column...

Lewis Dowson (11/11/2009)

---

lmu92, I agree you could do the same in one query but I find that it is both more maintainable and readable if you use the CTE method....

The only difference I can see is the word "SELECT" aat the beginning of the output...

SELECT 'Select '+ stuff((SELECT ', ' + Value From @Temp FOR XML path('')),1,2,'')

Based on your...

A decision whether to go for one or more database(s) is much more related to the context to be stored than...

Why don't you add the WHERE clause to your CASE statement and do all in one query?

To get the count for each group would be the same as do SUM(CASE...

I'm not sure if it helps to explicit cast the xml result as varchar(8000) or nvarchar(4000).

Another option could be to put the XML subselect into a separate (temp?) table with...

Thanxalot for the effort in (re-)writing this great article Jeff!

Adding cross-references to several other great articles and the amount of code to support/prove your point makes it not "only" an...

Usually, a ColToRowConversion of this kind is done using the FOR XML clause:

SELECT stuff((SELECT ', ' + Value From @Temp FOR XML path('')),1,2,'')

Using your sample data it will result in...

The problem is described pretty clear:

It looks like you're trying to open a file located on a client PC from a (SQL) server.

Either you...

What do you mean by "XL file"?

Is it a typo meaning XML structure or do you want to store an "eXtra Large" file?

If the former, please search for "XML Workshop"...

The problem is you're trying to do the insert twice:

1)

and

2)

You...