Post #1457375

@melindrea @isaackuo @mariyadelano but you learn so much while doing option B, and the next week you can apply that knowledge to something else... literally happened to me this week. I had to investigate as many as several dozen rows of a user activity audit log, the relevant parts of which are in an XML column. rather than spend several minutes looking at raw XML I learned how to parse the relevant bits into columns and rows in T-SQL and show the relevant data without surrounding boilerplate in a single view. then I used the same technique to analyse a bunch of data in a different table for a completely different purpose