I ran Jeff's CSV builder, and Peter's test code on my system. For good measure, I threw in the DelimitedSplit8K routine also (running against both a "real" and a virtual...

If you will post your sample data creation, I'll give it a test...

CirquedeSQLeil (9/12/2010)

WayneS (9/12/2010)

GilaMonster (9/12/2010)

Alvin Ramard (9/12/2010)

That OP is...

Alvin Ramard (9/12/2010)

I think part of his problem, on top of his poor communication skills,...

GilaMonster (9/12/2010)

Alvin Ramard (9/12/2010)

That OP is now on...

You're going to have to do something like:

DECLARE @test-2 TABLE (ColumnX char(1), ColumnY int);

INSERT INTO @test-2

SELECT 'a', 3 UNION ALL

SELECT 'b', 4 UNION ALL

SELECT 'a', 3 UNION ALL

SELECT 'a', 3...

The problem is that in order to really use the output clause to capture the identity column, and then subsequently use it in a child insert, you do need something...

steve-893342 (9/12/2010)

shell_l_d (9/10/2010)

The XML splitter that I used until you blasted it away with code did not use the ROW_NUMBER() function to return the position.

GilaMonster (9/12/2010)

The phrase "With friends like that who needs enemies"...

Jason Akin (9/11/2010)

This is a SQL 7/2000 forum... the cross apply won't work unless posted in the wrong forum.

Well, it looks like Gail made a new friend out of it. http://www.sqlservercentral.com/Forums/FindPost984310.aspx.

No problem.

But... please follow up and let us know how it works out for you.

Jeff Moden (9/10/2010)

mtillman-921105 (9/10/2010)

The Dixie Flatline (9/10/2010)