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 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
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)