Viewing 2 posts - 496 through 497 (of 497 total)
Here's another approach using partioning with cross apply. This also produces the desired result:
declare @t table (
Id int
, Id1 int
, Id2 int
, MasterId int
, Obs char(4)
, Dec...
April 8, 2014 at 7:59 am
#1704137
There are a couple of problems here. First off, PIVOT can only pivot one column (at a time). You could do separate pivots as subqueries for each of...
April 8, 2014 at 6:53 am
#1704118