OK. Excuse my lack of Unix knowledge here. If this is a start position/length scenario, why are...

If you are importing from Excel to SQL Server, where does XML come into it?

If you used pipes, they would not. But I take your...

Can you come at this from a different angle and instead change your delimiter? You'll probably have less trouble if you use a pipe (|), for example.

Larry Page(Ehsan.Akbar) (4/16/2012)

---

Phil Parkin (4/16/2012)

---

The longer I watch this thread unfold, the more troll-like it seems.

Perhaps you would provide a fuller statement of requirements to help us understand why you...

The longer I watch this thread unfold, the more troll-like it seems.

Perhaps you would provide a fuller statement of requirements to help us understand why you are doing this. And...

I don't think that Gail is a 'sir'.

edvard 19773 (4/15/2012)

---

Still thanks for having solved my immideate problem!

I am aware of, that your solution is much faster than a row by row solution, and in this case, its...

edvard 19773 (4/15/2012)

---

Did the trick - Thanks:-).

Not urgent, but how to make it in a WHILE loop instead.

I do not need it here, but it seems wrong, that i cannot...

Use Execute Package tasks instead?

If you have it installed somewhere, you could fire up Profiler and check the actual queries that are being sent from the front-end app. Might give you some clues.

Are the dnr_cst_key columns indexed in both tables?

slpgma (4/11/2012)

---

Not so sure that's a good idea for anything other than practice. If you did that in Bristol, RI, you're code would really be a problem because half...

5) Why should I do my own homework?

aarionsql (4/10/2012)

---

Hi Phil,

Many thanks! Thank you I have learned a new way of thinking and looking at things when I saw your reply. I will try and replicate your query...