Well then as Lowell said you can't do this with sql alone. This is more Lowell's expertise than mine but that is going to be pretty painful. You are going...

Charlottecb (9/21/2011)

---

Hi, thanks for the response. I have no control over the original dumping of the varbinary data - it' done by an external system which I have no control...

WOOHOO!!! Score +1 for bullseye shot in the dark. 😛

venoym (9/21/2011)

---

Michael,

Here's some food for thought for you. Use the split function that Sean mentioned to split the strings into tables. Then join them (full outer join) and...

So basically, the question is not how to split the arrays but how to loop through two split arrays so that I can capture every combination and execute the "real"...

Charlottecb (9/21/2011)

---

SQLServer 2008.

Problem: I have a table populated by an external system which stores image data in a varbinary column. I need to create a trigger on the table so...

OK...

What...

Michael A. (9/20/2011)

---

Wow, thanks fellas, nice replies! I appreciate the time to review and answer the question, err- waste your time with your answers about best practices and odd references...

And don't add an accidental space into Lowells naming convention. (WHORE SULTS). :w00t:

Which when I first read it i transposed the U and L in the second word....sheesh!!!

Remember my comment about making things easy for people to work on your problems by providing ddl, sample data and desired output. I provided that for you in a previous...

It returns EXACTLY what you asked for in your first post. What is the code you tried?

You edited your previous post while I was composing my response. Just change the order by in my above post to use Col3 and it should work for you.

Something like this should work then. Notice...

Certainly a cursor is not going to help much in the performance world at all. You need to come up with a set based solution for this instead of RBAR....