SQLRNNR (5/20/2011)

---

3% difference? Getting a 5% annual raise would be fantastic. Haven't seen too many of those. 1% is typically the cap at places I have worked.

The...

Congrats!

Hear, Hear! Well said.

aaron-403220 (5/19/2011)

---

The compounding of the incentives sounds really great but most companies will have an upper limit to a salary so you might have a difficult time achieving the 'full...

ChazMan (5/19/2011)

---

Now, this may sound naive...but do you work hard to get the raise or do you work hard because it is its own reward. Sure, getting a nice...

Upon further research, I found this tidbit:

"This is not true for all database implementations. In an Oracle RDBMS for example NULL and the empty string are considered the same thing...

Yes,...

I just keep wondering how I never heard of STUFF in 12 years working with SQL...

Maybe because people avoid using it for this reason??

Daniel Bowlin (5/18/2011)

---

SQLRNNR (5/17/2011)

---

bcsims 90437 (5/17/2011)

---

SQLRNNR (5/17/2011)

---

Brandie Tarvin (5/17/2011)

---

SQLRNNR (5/17/2011)

---

Ray K (5/17/2011)

---

bcsims 90437 (5/17/2011)

---

pinch

Hmmm, should I spend $60 to take me and my dog to...

Thanks for the easy question. It was so easy I was sure it was some kind of trick 😉

I spent more time looking at it.

SELECT STUFF('Vinay, Vijay, Amit',8,5,NULL)

is identical result wise to

SELECT STUFF('Vinay, Vijay, Amit',8,5,'') (those are single quotes)

I would never have expected that. I would...

jeff.mason (5/17/2011)

---

Burned by what SHOULD be versus what IS.

Logically, NULL plus anything should be NULL. Period, end of story. NULL means "unknown" and you can't assume that you...

SQLRNNR (5/16/2011)

---

Peter Trast (5/16/2011)

---

No, just a horrible song... some 70's music is best forgotten. Hey,...

Brandie Tarvin (5/16/2011)

---

Peter Trast (5/16/2011)

---

No, just a horrible song... some 70's music is best forgotten....

SQLkiwi (5/16/2011)

---

Peter Trast (5/16/2011)

---

The explanation makes plenty of sense. I was just wondering what the threshold is. "Significant" is subjective. I was hoping for a percentage or formula or something...