XML select
-
Could you help with XML select. Below is my xml however it won't select correct value.
DECLARE @input AS XML
SET @input =N'111111111111999999777777'SELECT
Ppl.GroupID.value('(@GroupID)', 'VARCHAR(6)') AS 'GroupID'
FROM
@input.nodes('/NewDataSet/GroupID') as Ppl(GroupID) -
Could you help with XML select. Below is my xml however it won't select correct value.
DECLARE @input AS XML
SET @input =N'111111111111999999777777'SELECT
Ppl.GroupID.value('(@GroupID)', 'VARCHAR(6)') AS 'GroupID'
FROM
@input.nodes('/NewDataSet/GroupID') as Ppl(GroupID)I do not understand what do you mean by
(@GroupID), but you should write it like this:Ppl.GroupID.value('.', 'VARCHAR(6)') AS 'GroupID'
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
