Yes. It first makes the directory (if not already there), deletes the spreadsheet (if already present),...

This should work for you:

declare @test-2 table (Staff_nbr varchar(20));

insert into @test-2

select 'Unknown_200'

-- un-remark the following line to work with 4 digit numbers

--UNION ALL select 'Unknown_2000'

;with CTE (staff_nbr) AS

(

select convert(int,...

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)

---

Wondering if there's a way to...

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)

---

Do you think the highlighted ORDER BY is sufficient to guarantee that the order of the INSERTS will be the same as the order of entries in...

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.