Expanding on my prior post...  (Sorry this is so long.  I know that a lot of people already know these details, but I think some people don't)

Programs that 'export' data...

I haven't analyzed your RegEx, but isn't there *inherent* ambiguity in certain situations that are impossible to definitively resolve?

What if the text of a field's data contains quote-comma-qoute, like this:

"1005","Rosamond...

Why?

It occurs to me that the best way to *understand* what is actually happening with your sorts, is to simply include each of your sort-expressions, verbatim, in your SELECT field...

I know I'm an old "procedure-oriented" dinosaur.

It's gut-wrenching to watch the contortions T-SQL developers have to go through to get the basic functionality of a "For Next" loop....

I have a question. When you use "ROW_NUMBER" against an actual table, doesn't the query processor actually have to physically access that table, maybe do some disk reads, even...

I'm on an older version of SQL Server, so maybe what I am about to suggest already exists in a newer version. It would be great...

Here's my two cents, FWIW: The fault for the effects of poor communication does not fall on the English language for it's lack of overly specific terminology. The...

Gift Peddie (12/22/2011)

---

On the other hand, employers sometimes see a salary as a way to push workers to their limits, burn them out, and impose strict requirements on the work...

Steve Jones - SSC Editor (12/7/2011)

---

Tony Palmeri (12/6/2011)

---

I dispute the notion that *all* laws (and all decisions) are arbitrary. Many perfectly good and just laws are made objectively by...

Steve Jones - SSC Editor (12/7/2011)

---

(...) It's easy to say I find a job on Monster, I apply, I get hired and agree to work for someone at...

Steve Jones - SSC Editor (12/6/2011)

---

Tony Palmeri (12/6/2011)

---

sqlnyc (12/6/2011)

---

Everyone has a right to complain, whenever and about whatever they want - that's the very essence of free speech. Your opinion...

sqlnyc (12/6/2011)

---

Everyone has a right to complain, whenever and about whatever they want - that's the very essence of free speech. Your opinion is welcomed here, as are the opinions...

I stand by my statement. If you advocate for such laws, you have no right to complain when those laws affect you in ways you don't like.

I have exactly ZERO sympathy for anyone who is an advocate of any kind of Federal Regulatory interference into how any company compensates it's employees. If you do advocate...