February 27, 2008 at 10:47 pm
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.
February 27, 2008 at 11:26 pm
February 27, 2008 at 11:29 pm
Wow ... Thks Anirban Paul. i got it 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply