Please post more detailed information (including execution plan) as described in the second link in my signature.

Please don't cross post. Same question (to be used for further assitance) asked here .

Please see my previous post:

You're doing a SELECT FROM MyTable. This will result in...

Assuming you have your xml data stored in an xml variable named @xml, I'd use the following code:

;WITH cte AS

(

SELECT

c.value('@id[1]', 'varchar(10)') +'-'+

y.value('LabelType[1]/@id[1]', 'varchar(10)')+'-'+

y.value('Label[1]/@id[1]', 'varchar(10)') a

FROM @xml.nodes('strinfo/choices/choice') t(c)

CROSS APPLY

t.c.nodes('Labels/Label') x(y)

)

SELECT...

It seems like the service you provide doesn't meet the requirements of some users.

Sounds like there are some people out there looking for a way to get lists rather than...

The problem is that your statement

SET @fName = (select [something] from MyTable)

will return one value for every row in MyTable, which cannot be assigned to a variable of the data...

I don't know if there's an easier way to do it but here's what I came up with (using UNPIVOT and PIVOT):

DECLARE @tbl TABLE

(id INT,

c1 CHAR(1), c2 CHAR(1), c3...

Ooops!

Could you...

I would not use two different strategies.

What I would recommend to do:

Take the insert without any value for parentid. Set this column to a default value that will identify parentids...

Is the insert statement the only statement in your proc?

Or are you using a cursor by any chance?

Would you mind sharing the overall concept of your procedure as well as...

never mind. Didn't read the whole story before answering. Sorry.

T-SQL_NewBie (2/6/2010)

---

How would my insert statement look like if I need to insert a new record and relate to its parent 6 digit number

ABC00000000001 ABC Shipping Inc ...

Matt Miller (#4) (2/6/2010)

---

...

Careful about the usage folks. If you happen to read these messages backwards... DBCC TimeWarp also performs a DBCC MindWarp on the person at the keyboard...

Ok, here's what I came up with:

;WITH Repeats AS

(

SELECT 1 AS parent, 6 AS Cnt UNION ALL

SELECT 2,10 AS Cnt UNION ALL

SELECT 3,14 AS Cnt

),

cte AS

(

SELECT

ROW_NUMBER() OVER(ORDER BY CompanyName,parent...

CirquedeSQLeil (2/6/2010)

---

The Dixie Flatline (2/6/2010)

---

Fine then, Mr. Wings-On-Your-Hat-And-Feet-Man with the vaguely French name.

I'll just get my answer off Twitter.

I wave my subatomic particles at all of your...