Hi All,
I am writinng following query.
select distinct 1 as tag,
null as parent,
OriginAirportCo de as [Origin!1!id],
null as [DestinationAirp ortCode!2!id!id ref],
null as [DestinationAirp ortCode!2!Conne ctingAirportCod e!idref],
null as [DestinationAirp ortCode!2!IsFut ureFlight!idref] from RouteMap
union all
select distinct 2 as...
User Profile
Collapse
-
MSSQL/Related to XML Query
-
For Xml Explicit//mssql
Hi All,
I am writinng following query.
select distinct 1 as tag,
null as parent,
OriginAirportCo de as [Origin!1!id],
null as [DestinationAirp ortCode!2!id!id ref],
null as [DestinationAirp ortCode!2!Conne ctingAirportCod e!idref],
null as [DestinationAirp ortCode!2!IsFut ureFlight!idref] from RouteMap
union all
select distinct 2 as...
No activity results to display
Show More