I used this time last year to create a stored procedure to show me column by column log/audit table changes. So when a user asks when a specific record has been modified, I can run the procedure to give the user the changes made, who made the changes and when the changes were made. It was eventually added to the end user application so they can run it themselves.
I was able to use a combination of "new" features found here on SSC including the "FOR XML", "UNPIVOT", "DENSE_RANK". Learned a ton from enhancing this over the past year.
Thanks for all of the help, motivation and insight