But FG didn't... and won't. It's a waste of time and I'd rather spend the time helping people who don't need to be changed. Heh... pork chops are...

RBarryYoung (3/24/2009)

---

GilaMonster (3/24/2009)

---

RBarryYoung (3/24/2009)

---

It's like the old joke:

Q: How many psychiatrists does it take to change a light bulb?

A: Only one. But it takes a very long time and...

notes4we (3/24/2009)

---

Lynn. Your code worked fine. I was a bit confused with few columns as the table is huge.

Anyways, I have figured out the reason why it did not work....

BWAA-HAA!!! Hopefully, you're not the one driving. 😛

GSquared (3/24/2009)

---

lmu92 (3/24/2009)

---

We have a saying over here...

karthikeyan (3/24/2009)

---

lmu92 (3/23/2009)

---

I'm just wondering:

is your question related to the country to outsource from or to outsource to? :hehe:

Aside of that, you're normally not outsorcing to a country but to...

One more thing.... can you post the code for the UDF that uses my method... and why are you using a UDF for this? It was meant to resolve...

And, yes... there's a few more tricks we can try.

jchandramouli (3/23/2009)

---

Jeff,

I have used your script both in UDF and as a query. But the problem is when the table records exceeds 10000, there is a performance issue. It takes...

Chirag (3/23/2009)

---

Jeff

I mistook this (1230-544,15C5487,132DE78) for a single value rather than 3 values that they are. I assume the op wanted to process one value.

Using a number table would...

I had summed the column that came from the CTE... it caused wrong answers almost as if...

ramu.valleti (3/22/2009)

---

Yes Jeff Moden,

I'm back..!

The query i was thinking is similar to your query, and here is mine..

SELECT t1.zone,t1.Class,COUNT(Item) Cnt

FROM

(

SELECT zone,Class,Item,SUM(sales) sales

FROM sales

GROUP BY zone,Class,Item

)t1 INNER JOIN

(

SELECT zone,Class,SUM([sales]) sales...

Shoot... they can't even get it right with simple pretty pictures... DTS, SSIS, and...

vwilliams (3/23/2009)

---

It is taking parameters from an application and getting information to display to an aspx report. The problem is one of the fields (phra_request_querystring) is a string that...

Heh... Detroit... where weak developers are killed and eaten and there is no night when there's a deadline. 😉