As usual: it depends.

A few questions (aside of the standard questions for server load, available CPU a.s.o.):

How many...

Sounds like a job for Jeff Modens Dynamic CrossTab[/url].

Please follow the link and let us know if you get stuck again.

edit: identical post.

edit: identical post.

untested, but it should work:

IF EXISTS(SELECT 1 FROM mytable WHERE name ='myname')

SELECT name, address, '12345' as zip from mytable WHERE name ='myname'

ELSE

SELECT 'name' AS name, 'address' AS address, '12345' as...

Using your sample data from above and the CTE you already provided I added another recursive CTE to get the total amount of products pe section id.

Then I eliminated all...

Would something like the following help?

Please note the way sample data are posted...

DECLARE @Number Table (Number int, Status_id int)

INSERT INTO @Number

SELECT 123400 ,1 UNION ALL

SELECT 123401 ,2 UNION ALL...

Here's an example that might work. It's completely untested due to the lack of sample data. Therefore, I used a SELECT instead of DELETE statement.

It doesn't require the temp table...

;WITH...

It would be really helpful to see the proc itself than guessing from what you described.

Based on your description: it's unlikely to happen...

One reason you don't have any replies yet might be that it takes too much effort to create a test environment.

Please read and follow the link in my signature on...

What have you tried so far?

If you don't have a point to start at:

You need a CROSS JOIN between your GROUPed numbers (reduced to either the LEFT 4 character or...

Scar tissues are distinctive marks for front line warriors!

And you're definitely one of them 😉

Once it a while it's required to point out that we're all volunteers who are willing to help. The link above is just one possible way to transfer the message....

Grant Fritchey (9/17/2009)

---

Actually, I think that one was just a misunderstanding. He didn't get that Jeff was showing him how to set up a test for his index... I think....

This link should help you further.