Jack Corbett (2/26/2009)

---

Back to trying to get newbies to read the articles, instead of having a popup or anything, is there a confirmation email that goes out when you register...

Write a function to do it. There are methods of converting numbers to text from 0 up to one million and all numbers in between, but you're working with quite...

Cheers! Looks a lot like homework hey?

Nah that's a different Chris Morris,...

See also here.

See also here.

Use the spaces before and after the word 'User', like this:

REPLACE(mycolumn, ' User ', ' Employee ')

Grant Fritchey (2/25/2009)

---

I agree with Jack and Barry. Yes, I try to post that way all the time. No, I don't think we need to get into sweating standards like...

Lynn Pettis (2/24/2009)

---

Alvin Ramard (2/24/2009)

---

Yesterday was an interesting day on here. I don't think any of the posters were picked on, except for a quick reference to a White.house...

Bob Hovious (2/24/2009)

---

There was also an abortive discussion about the unreasoning prejudice of humans against short, scaly, lizard-looking aliens with big ears and bad grammar. Steve may have...

Yes, but you will need to provide much more information -...

Some individual posts are gems and worthy of being saved as articles. It would be real handy to be able to put such articles into the "briefcase".

You should spend a little time reading the earlier replies from Steve Jones and Bitbucket.

Also, check out "table alias" and "derived table" in BOL.

Yep...he's been working full-time on the same code - the same statement goddammit - for...

Thanks Bitbucket, that one's new to me! I assumed that the error was from this..

WHEN 'Deniel of Grade' then 'DN'

WHEN 'Absent' then...

Start with something small and straightforward. Work with it until you understand it and you're comfortable with how it works, and progress from there.

Building a large complex query and...