homebrew01 (11/11/2009)

---

The original post is much easier to understand. Consider someone looking at or modifying the code a year from now, and the risk of introducing bugs or errors. ...

What is the root cause to have the validation implemented in almost every proc?

As far as I can see, there should be room for improvement in terms of the frequency...

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...