WayneS (6/24/2009)

---

For those that use the FireFox web browser (you can stop reading now Jeff:-)) - what do you use for blocking ads? The one I used wrecked havoc on...

jcrawf02 (6/24/2009)

---

Has codez, needs brainz . ..:-P

Ok math geeks. My poor little head can't wrap around why I get different results for these, and hoping you can help.

Trying to...

Paul White (6/23/2009)

---

RBarryYoung (6/23/2009)

---

It looks like my code got partially garbled when they tried to format it for the article. I have attached the actual code in a text...

It's not happening on my server.

Try executing this script and show us what the results are:

CREATE TABLE #utbQuote(

[Name] [varchar](30) NOT NULL,

[RequestDate] [datetime] NOT NULL,

[Cost] [money] NOT NULL

) ON [PRIMARY]

go

set nocount...

Roy Ernest (6/23/2009)

---

Hey Barry, That movie star , what is his name Redford?? He looks just like you...:-) He must have been one pleased man to look like you... Just...

Paul White (6/23/2009)

---

Actually, that looks pretty awesome!

I'd like to try it for myself - but has...

They wouldn't let me use that one I wanted too, though. I have attached it here for...

GSquared (6/23/2009)

---

My favorite line isn't even in the code. It's, "you can find below the...

Heh, Thanks Doc. One of the benefits of a...

Paul White (6/23/2009)

---

Actually, that looks pretty awesome!

I'd like to try it for myself - but has...

Now, if you want to see some truly hideous code, try this. 🙂

Actually, I suspect that that's little Snarky trying to tip-toe around,,,...

All right, now stop that!

😛

Jack Corbett (6/19/2009)

---

Another week, another few hundred posts to read through. At least we found out Roy isn't as fat as Jabba the Hut and Barry isn't a lawyer....

Like this:

Select distinct p.ClaimNumber

From MedicalProcedure p

JOIN Diagnosis d ON d.ClaimNumber = p.ClaimNumber

WHERE p.ProcedureNumber = 8694

AND d.DiagnosisNumber 4019