Hello,
can you please help me getting this code as a pivot.
Select (select Description from PricePlans where PricePlanID = PricesZone.PricePlanID) AS [PlanName],
(select Description From Zones where ZoneID = ZoneFromID) AS [FromZone],
(select Description From Zones where ZoneID = ZoneToID) AS [ToZone],Price
From priceszone where PricePlanID in (1529,1528,1527,1526) AND (ZONEFROMID = 105 OR ZONETOID = 105)
ORDER BY (select Description from PricePlans where PricePlanID = PricesZone.PricePlanID) ,FromZone, ToZone
Any help is appreciated.