you might want to search for "split string function" on this site. There are many solutions available.

Now that's obviously an OP "who knows how to behave".... Calling Jeff a .... (my fingers actually refuse to retype the word and cut and paste won't work either).

Combined...

Would you mind sharing what you've tried so far and what you have trouble with?

Btw: strange requirement though.... what's the business reason behind it?

Hi, a couple things to notice:

XTLID, ServicerName, and LoanNumber are elements, no attributes. Therefore, you cannot use @XTLID.

You cannot jump right in the middle of an xml structure with...

What have you tried so far?

If have nothing to start with I'd like to recommend to search for "split string function" on this site. There are many solutions available.

If you...

Please read and follow the link in my signature on how to post sample data.

You could also check one of Jeff's articles regarding Cross Tabs[/url].

Please see http://www.sqlservercentral.com/Forums/FindPost679589.aspx.

The ROW_NUMBER () OVER (PARTITION BY ... ORDER BY) will simply number the rows for each activityid and day starting from 1 ordered by startdatetime.

By looking at your real life...

We're using a VersionControlTable to verify if a proc or table has been altered / added or deleted.

From my point of view both concepts have their advantage and disadvantage.

With Lowells...

Supporting GSquared's advice I'd like to add one more thing that may help you in addition:

Try to get a (small) test database you can play with and apply the concept...

Glad you found a solution. 🙂

Maybe this link will answer your question.

If not, please follow the link in my signature on how to post sample data.

Since you hide any sample data I had to come up with a short example...

I used XQuery instead of OPENXML since I don't know what version you're using either...

As you...

If there's anybody around loosing his/her faith in the existence of the "Perfect OP":

I guess I found her: http://www.sqlservercentral.com/Forums/FindPost789155.aspx

- Good description of the problem

- Ready to use data

- expected result...

Good job, again!

It's great to see that there are still some people out there that aren't relying on a forum answer only. This makes it a lot more fun to...