User Profile

Collapse

Profile Sidebar

Collapse
mystiqueneha
mystiqueneha
Last Activity: Jun 21 '06, 11:15 AM
Joined: Jun 21 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mystiqueneha
    started a topic MSSQL/Related to XML Query
    in SQL Server

    MSSQL/Related to XML Query

    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...
    See more | Go to post
    • mystiqueneha
      started a topic For Xml Explicit//mssql
      in SQL Server

      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...
      See more | Go to post
      No activity results to display
      Show More
      Working...