Well look at that! Thanks so much! 🙂

Thanks for the reply. So far I have found suggestions to edit the XML data conversion config file (which may get me fired), create a View from the query and...

Okay, apparently if I change databases and run any query against the new DB, then switch back and run IS_ROLEMEMBER it provides the "refresh" I need, but I would prefer...

Thanks folks. I will give this another go once my IT folks fix my permissions issues to the share drives.

Ha! Thanks. Our DBA called and said exactly that. Now I am working through file permissions between our destination server and file share. I guess I'm getting closer.

Thanks.

Steve and Sean:

Believe it or not they actually REMOVED any meaningful data from the ID structure before approving them. These IDs are similar to GUIDs in their uniqueness, but are...

Good point Michael. So far, everything I am seeing in my searches seems to indicate I can very easily do without a UDT. I am thinking I may avoid them.

Kurt

Thanks Lowell. Yup, implementation is up to me.

For starters, I always use autogenerated PKs anyway, and won't be losing those. I just need to record the two different IDs....

Sadly the decision to use this ID structure was made 12,546 miles above my pay grade, so I can't really tell you why the numbers were structured that way. But...

Steve, that did it! I am a bit embarrassed that I didn't think of a simple MAX() function. That was slick and spot on. Thanks.

Kurt

I am still trying to wrap my head around CTE and Partition and OVER. In the meantime, here are the table defs. Table aspnet_Membership was what I referred to as...

Thanks folks. I will see if I can create some generic example code.

I have not worked with CTEs and partitions, so I'll have to do some research on those. But...

Excellent! That's what I thought. Thanks.

Kurt

Okay all, just got out of a meeting and went back to it. I think I have it all sorted except for one, tiny portion:

, 'StorageLocation'

= STUFF

(

(

SELECT ','

+...

Thanks Sean and OPC:

I figure it just bites you on the.. uh, ankle... later on if you don't follow what was given. I had no idea that FOR XML could...