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.

you might want to search for "split string function" on this site. There are many solutions available.

Now that's obviously an OP "who knows how to behave".... Calling Jeff a .... (my fingers actually refuse to retype the word and cut and paste won't work either).

Combined...