In this post I have not used PIVOT anywhere. Sorry, but i am not sure which post you are referring. I think you are referring http://beyondrelational.com/modules/2/blogs/51/Posts/19513/convert-xml-data-to-sql-table-data.aspx post.
If so, then you can read more about using x-query. In xquery we give an alias to the node and then refer in the main query, so f.x ant t.c are same.
PIVOT is used so as to i can transform the data output from columns to rows to get all the values for one record in a single row.
commented on Jun 26 2013 3:09AM