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.
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.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 15 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.