MatchId SelectionName Odds 322 Home Win 1.33 322 Draw 5.00 322 Away Win 9.00 322 Under 2.5 2.40 322 Over 2.5 1.53
MatchId Home Win Draw Away Win Under 2.5 Over 2.5 322 1.33 5.00 9.00 2.40 1.53
select * from (select MatchId,SelectionName,Odds From #tmpMatchOdds) As P Pivot ( Sum([odds]) For SelectionName In ([Home Win],[Draw],[Away Win],[Under 2.5],[Over 2.5]) )As pv
Select MatchId,[Home Win],[Draw],[Away Win],[Under 2.5],[Over 2.5] From TableName PIVOT ( SUM(Odds) For SelectionName in ([Home Win],[Draw],[Away Win],[Under 2.5],[Over 2.5]) ) as pvttbl
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)