Sounds like...

WayneS (9/8/2010)

---

Something like:

CREATE TABLE Book (BookID int....)

CREATE TABLE Borrow (BookID int, ...)

INSERT INTO Book...

Something like

SELECT ROW_NUMBER() OVER(PARTITION BY EMPID, ROLE ORDER BY ROLE)

Not really....

Sample data in a ready to use format and expected result, please.

WayneS (9/7/2010)

---

Steve Jones - Editor (9/7/2010)

---

Actually I picture Lutz as Wayne's...

Please readand follow the advice given in the first article in my signature.

It's unlikely you can motivate a lot of people looking at image references to see table descriptions.

Please provide...

tonyclifton77 (9/8/2010)

---

The language is supposed to be XQuery (I know the keywords shouldn't be in capital letters) 🙂

My main problem is to transform the loop-construct to work with TSQL-Syntax,...

@john-2:

Since David addressing his issues implicit to your attention ignoring other posts, I leave this thread in your hands.

I tried using different kinds of format files but I heven't been able to import directly into the target table.

When I'm facing such circumstances and can't find a workaround I...

I might have a solution but I need some sample data to test it against.

Especially, there's one issue that needs clarification: let's assume your first xml column has 5 nodes...

jcrawf02 (9/7/2010)

---

LutzM (9/7/2010)

---

jcrawf02 (9/7/2010)

---

Do you suppose 5 minutes to return one row of data will be too much for end users? 😛

Now I just have to figure out what the...

As...

Did you try using bulk insert instead of bcp? Seems to work...

I created a file test.txt holding 2010-09-07 10:40:03.000.

The following code did work without any issues:

DECLARE @tbl TABLE

(

col1 DATETIME...

mashikoo (9/7/2010)

---

Here is the an example of the end result:

Last name first name Status

Doe John ...

As stated before:

Please read and follow the instructions given in the article referenced as the first link in my signature ("How to get fast answers to your question").

You need...