Relative

The reason is that the two parts of your CASE statement return different data types. SUM returns an integer and 'No data available' returns a varchar. If you...

Jack Corbett (11/18/2014)

---

Evil Kraig F (11/18/2014)

---

*stares at 3 pages of spammers*

Steve... can you convince the powers that be to put up a 'board of shame' or something on...

Jeff Moden (11/18/2014)

---

Do you mean you want to remove all non-numeric-digits from the column? ...

Eric M Russell (11/18/2014)

---

I wonder how many ordinary people superficially maintain a FaceBook page, not for dumping their actual daily life, but just for use as a presentable shill for...

In SQL, a calculation can be performed as an expression in the column list of the SELECT statement. I'm not sure of what your question is either. Could...

Gary Varga (11/18/2014)

---

Stefan Krzywicki (11/18/2014)

---

BWFC (11/18/2014)

---

Stefan Krzywicki (11/18/2014)

---

cackalackian (11/18/2014)

---

Would you want aspects of your life, perhaps data outside of your health (think driving, finance, etc) to be part of the...

BWFC (11/18/2014)

---

Stefan Krzywicki (11/18/2014)

---

cackalackian (11/18/2014)

---

Would you want aspects of your life, perhaps data outside of your health (think driving, finance, etc) to be part of the evaluation (or negotiation) process...

I don't know that I'm qualified to make decisions about how people live their lives and the impact that will have on their costs in the future. All the...

Another wrinkle is that the databases could be installed in different directories. I don't have mine that way, but it could be done. If you query sys.master_files, it...

I'd recommend DelimitedSplit8K as well. If you want to split on the carriage return, split by CHAR(10). Splitting by a comma is simply ','.

To remove one character, use the REPLACE function. I suspect there's slightly more to it than that, so like Gianluca said, please post an example. It's best if...

Steve Jones - SSC Editor (11/17/2014)

---

Ed Wagner (11/17/2014)

---

Steve, let me...

Taproot

Really nice question. Good way to get the brain moving on a Monday morning.