The only known part of the required sequence...

Hi Arun

as regular SQL it will look like this...

SELECT r.resolution, ISNULL(sq.CaseCount, 0) As CaseCount

FROM tlkResolution r

LEFT JOIN (SELECT c.resolutionID, Count(Distinct c.caseID) As CaseCount

...

ALZDBA (12/19/2008)

---

Finaly we are getting to the essence of being :w00t::w00t:

beer and food 🙂

I prefere a very good Geuze Lambic (the bottle with natural cork please) :smooooth:

I'm not that...

Arun, please could you post your final working code? Not only does it finish the thread nicely, it may also stand as...

If you can figure out the rules, it shouldn't be too hard to figure out the code.

Debbie Edwards (12/19/2008)

---

Thanks :ermm:

I think the best thing I can do is try to figure out another simpler way, Im out of my league a bit here.

Im hoping there may...

Grant Fritchey (12/19/2008)

---

Nothing wrong with both beer and a good scotch. Preferably some incredibly hoppy IPA or ESB and some Scapa.... mmmm... Oh, look at the time. The sun just...

arun.samuel (12/19/2008)

---

I would like to get this script to work, it keeps saying:

"Only one expression can be specified in the select list when the subquery is not introduced with EXISTS."

Here...

Someone said beer I swear...

Nicest beer this week was Blue Moon wheat beer from Denver, CO, purchased from Sainsbury's, Reading, UK.

ddorfman (12/19/2008)

---

Hi

I can see that it would be difficult to assess my problem from the chunk of code i placed down. But i can assure you the only difference...

Debbie Edwards (12/19/2008)

---

Ahhhh

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows NT...

:D:D

Debbie, I can see from some of your earlier posts that 2k5-specific code invariably fails...

mdowns (12/19/2008)

---

But that's not going to give you what you said you want. I'm debugging this in my head but if both strings have 10 digits then the "select" is...

It's a SQL Server 2005 function, and...