Sign in
|
Join
|
Help
Search
TSQL Challenges
TSQL Challenges intend to help you to test and enhance SET based querying skills using TSQL.
Home
Contact
About
RSS for Posts
Atom
RSS for Comments
Recent Posts
TSQL Challenge 10 – Solution by Divya Agrawal
Tags
Challenge
Challenges
CTE
Divya
leonidk
Puzzle
puzzles
Rob
Solution
Split
SQL
SQL Server
SQL Server Challenges
Syed
TC_Challenge
TSQL
TSQL Challenge
tsql challenges
TSQL Puzzle
TSQL_Challenge
TSQL_Challenges
TSQL-Challenge
TSQL-Challenge-Answer
TSQL-Challenge-Results
Winners
Community
Home
Blogs
Media
Forums
Wikis
Groups
Email Notifications
Go
Links
TSQL Challenge Forum
Twitter
Linked in
facebook
Interesting SQL Server Blogs
Home
View all challenges
Archives
March 2010 (11)
February 2010 (9)
January 2010 (5)
December 2009 (6)
November 2009 (11)
October 2009 (5)
September 2009 (5)
August 2009 (3)
July 2009 (8)
June 2009 (12)
May 2009 (10)
April 2009 (10)
February 2009 (1)
Browse by Tags
All Tags
»
Divya
(
RSS
)
Solution
TSQL Challenge 10 – Solution by Divya Agrawal
Divya has an original solution based on XML data type methods and PIVOT operator to perform the required sort operation for this challenge. XML Data type is a great feature added in SQL Server 2005. While XML methods can be used to solve...
Posted:
09-24-2009 9:34 AM
by
David Barbarin
| with
5 comment(s)
Filed under:
Solution
,
Divya