Join with XML

• SqlUser-529296

  SSCarpal Tunnel

  Points: 4072

  More actions

  February 27, 2008 at 10:47 pm

  #184374

  Hi All,

  DECLARE @XML XML

  SET @XML =

  '

  '

  SELECT @XML

  SELECT nref.value('ID[1]','varchar(8)') AS ProductID

  FROM @XML.nodes('//Product1') AS Product(nref)

  From this xml, is it possible to join with any table especially inner join with the xml SELECT.

• Anipaul

  SSC-Insane

  Points: 24681

  More actions

  February 27, 2008 at 11:26 pm

  #783000

  It is very much possible. Read this.....

  http://thetrainerph.spaces.live.com/blog/cns!9F717AF2A2401F0F!530.entry

  http://technet.microsoft.com/en-us/library/ms345115.aspx

  http://blogs.msdn.com/mrorke/archive/2005/07/21/441554.aspx

  http://www.jasonfollas.com/wiki/SQLXML.ashx

  

• SqlUser-529296

  SSCarpal Tunnel

  Points: 4072

  More actions

  February 27, 2008 at 11:29 pm

  #783001

  Wow ... Thks Anirban Paul. i got it