Why not simply using the "old-fashioned" method?

SELECT

xmlFileName,

c.value('SSN[1]', 'varchar(30)') AS ssn,

c.value('TaxableWages[1]' , 'varchar(30)') AS TaxableWages

FROM XmlImportTest

CROSS APPLY

xml_data.nodes('ROOT/Employee') T(c)

If this solution doesn't give you the desired result you might want to...

Please provide ready to use table def and sample data as described in the first link in my signature. It'll help us help you.

@ Ken

Please provide ready to use table def and sample data together with expected result as described in the first link in my signature.

@mrpolecat

What exactly is the difference of the...

And I say shame shame shame shame shame, SHAME ON ME! 😉

I should have spotted it right away...

Regarding your questions:

1 Can you reproduce this?

2 If yes, why would this happen?

3...

grevesz (7/6/2010)

---

Hello Lutz,

I was talking about the SELECT statement in this thread posted yesterday at 4:12:48 PM:

...

This statement, when I run it, returns case when ts_order.trans_type BUY_SELL, as the...

Glad I could help 😀

I don't quite understand.

What section or character...

grevesz (7/5/2010)

---

Hello Guys,

Thanks a lot for the explanations and ideas. This is a lot for me to digest, so please bare with me for a day (or two). I am...

bryan.duchesne (7/5/2010)

---

boy... that was fast... I didnt have a chance to edit my post before your replied but sadly that didn't seem to do the trick. I still...

Something like this?

INSERT target (field1, field2, field3,.....)

SELECT field1, field2, field3

FROM Source

WHERE NOT EXISTS (SELECT 1 FROM target t2 WHERE t2.field1 = Source.field1)

Lowell (7/5/2010)

---

well...this does what you wanted, but look at the results based on your sample data....it's appending a bunch of CASE WHEN statements and stuff....is that what you wanted?

this statemnts...

First of all: Thank your for providing ready to use sample data!! 🙂

Made it really easy to focus on the subject!

Here are a few items I run across while...

Regarding question #4: Did you try to right click on the function in question and select "Modify"? 😉

As a side note: It seems like all you want to do is get a comma separated list columns ofr a table specified by @an_export_id.

If so, there are concepts available...

rajendra prasad-377679 (7/3/2010)

---

...

now i am working in one organisation they ask me to write the program for that scenario using cursor..

that s y i ask help to the experts..like u...