You searched the blog entries for the tag t-sql.
Regrouping is something that I've had to do many times during my career in data analytics, unfortunately a lot of relationships aren't defined through a single unique identifier, at least not at first. This code snippet is designed to flush out the transitive relationships defined between pairs of elements and assign all elements in the graph a single unique identifier. Get ready for some SQL looping action...
Keep track of new posts by subscribing to the latest posts RSS feed.
View the whole tag cloud