Amusing and fairly easy question.

The misprints in the explanation may have left some people confused. All three alias forms are wrong (1st missing "= <", second and third bpth...

I think you've been given good advice. Often it turns out to be worth putting effort in in order to split historic data from production data, because the advantages...

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

---

roger.plowman (9/12/2011)

---

I keep seeing the chest-pounding developers who claim if you don't know how to implement low-level structures in C (or equally low-level languages) that...

Jack Corbett (9/9/2011)

---

One thing I'd add is a willingness/desire to continue to learn. In my relatively short-time in the industry I've seen plenty of people with 20+ years experience...

None taken, Steve.

I should have put a...

djackson 22568 (9/11/2011)

---

Huh?

First off, there may be hoardes of algorithms to sort, but I laugh when young developers try to tell me how Java can sort faster than the quick...

Gianluca Sartori (9/12/2011)

---

If you think that my reply was not called for, I can delete my post.

Well, actually I can't, but I can ask Steve to do it for me.

If...

Gianluca Sartori (9/12/2011)

---

Tom.Thomson (9/12/2011)

---

ChrisM@Work (9/12/2011)

---

WayneS (9/11/2011)

---

The last sentence...

marklegosz (9/12/2011)

---

I think those of us who have had the "pleasure" of working with case sensitive collations had a distinct advantage in answering this question.

But a great question for those...

OK, here is new code. I haven't tested it with cases where the email is missing or the phone number is missing, so let me know if there is...

OK, with proper table definitions and test data it becomes clear that there are multiple lnkphone records per patient. I had assumed only one. New code to follow...

OK, I made some guesses at table definitions, as follows:-

'create table patient (

dbpatcnt int, dbpatfirstname varchar(30),dbpatlastname varchar(30), dbstatusid int)

create table lnkphone (dbkeycnt int, dbphoneid...

ChrisM@Work (9/12/2011)

---

WayneS (9/11/2011)

---

The last sentence says it all...

Thomas Abraham (9/12/2011)

---

cengland0 (9/12/2011)

---

I got it right but for the wrong reason. The reason specified was for case sensitivity but I thought of other reasons it wouldn't run. ...

CELKO (9/11/2011)

---

While temp tables in the Sybase/SQL Server model can be indexed, constrained, etc. nobody does. They really are like a deck of punch cards. Compare this to the ANSI/ISO...