|
|
-
Anthony Faull Solved 1 Years ago through Puzzles | 5 Points
This solution uses PIVOT and UNPIVOT, subqueries, CROSS APPLY, ROW_NUMBER, modulo arithmetic, ASCII, XQuery, and REPLACE.
|
-
Anthony Faull Commented 1 Years ago through Puzzles | 1 Point
This solution uses PIVOT and UNPIVOT, subqueries, CROSS APPLY, ROW_NUMBER, modulo arithmetic, ASCII, XQuery, and REPLACE.
|
-
Anthony Faull Solved 1 Years ago through Puzzles | 5 Points
This code uses a recursive common table expression (CTE) and a ranking function. The anchor member ranks the episodes for each dated item. The recursive member appends the undated items until the maximum sequence number is reached. The MAXRECURSION option
|
-
Anthony Faull Solved 1 Years ago through Puzzles | 5 Points
This code uses a recursive common table expression (CTE) and a ranking function. The anchor member ranks the episodes for each dated item. The recursive member appends the undated items until the maximum sequence number is reached. The MAXRECURSION option
|
-
Anthony Faull Commented 1 Years ago through Puzzles | 1 Point
This code uses a recursive common table expression (CTE) and a ranking function. The anchor member ranks the episodes for each dated item. The recursive member appends the undated items until the maximum sequence number is reached. The MAXRECURSION option
|