摘要: set statistics io on set statistics time on SELECT distinct o.OrderID,f.Flight,f.DPort,f.APort,f.TakeOffTime,f.ArrivalTime,f.SubClass, f.Sequence,ISNULL(f.RecordNo,'')AS Pnr,o.FlightClass,c.ContactName, [value]=(select stuff((select ',' + PassengerName from O_Passenger p1 (nolock) wh 阅读全文
posted @ 2013-01-30 13:31 狼-志 阅读(425) 评论(0) 推荐(0) 编辑