Hi Paul

Can you post a little sample data please? I'm sure this can be done more efficiently.

Eugene Elutin (4/26/2012)

---

Without knowing what your tables are and what your full query is, the maximum what I can come up with:

SELECT t.ApprovalID

,u.UserName ...

Why not post the desired output. All of it, from your sample data set.

oolawole (4/25/2012)

---

Thanks for that, but it will not solve it. I'll explain again.

For each of the resp_Id, i want a count on each brand (that the resp_Id has) in this...

Ask yourself how you would cope, as a professional SQL Server developer, if you were given the content of your first post as a job specification.

It's awful.

What you...

noitisntitsnearlytwo

In a column of a SQL Server table? Have you tried LIKE()?

FollowedByAnother :-))

What column from which table are you trying to evaluate MAX() of?

Currently you have a "circular" evaluation - the MAX() of something which is never assigned a value.

Lisa Slater Nicholls (3/23/2012)

---

Hi Jeff, I'll have to look into it at home - this gig is 2k5 only 🙁

I did a lot of work on exactly this subject, attempting...

EasyBoy (3/23/2012)

---

Is there any way i can make below query more simple ?

There are total 5 queries with 5 temp tables. I need to make it simple using just one...

Jeff Moden (3/22/2012)

---

ChrisM@Work (3/19/2012)

---

This is pretty fast too:

SELECT n = (n1 + n2 + n3 + n4)

FROM (((VALUES (0),(100),(200),(300),(400),(500),(600),(700),(800),(900)) t3 (n3)

CROSS JOIN (VALUES...

This is pretty fast too:

SELECT n = (n1 + n2 + n3 + n4)

FROM (((VALUES (0),(100),(200),(300),(400),(500),(600),(700),(800),(900)) t3 (n3)

CROSS JOIN (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) t1 (n1))

CROSS...

Jonathan AC Roberts (3/13/2012)

---

Just to end arguments over performance I tried this:

DECLARE @StartTime datetime

DECLARE @x int

DECLARE @y varchar(20)

DECLARE @MaxIterations int

SET @MaxIterations = 10000

SET @StartTime = GETDATE()

DECLARE @i int

SET @i =...

andrew.diniz (3/13/2012)

---

...Moreover, the recursive CTE solution scales better. Sourcing the parameter list from an underlying table becomes more expensive as the table grows while recursive CTE solution does not. Even...