Using a variable in a SQL Server 2005 stored procedure with XQuery?

You need to approach this a bit differently: since you have a list of Element nodes, I would suggest you create a list of nodes and then pick the right one from that list - something like this: SELECT AED.Element. Value('(@Label)1', 'varchar(100)') as ControlLabel FROM Control CROSS APPLY Control_XML. Nodes('/AEDControl/Elements/Element') AS AED(Element) WHERE AED.Element.

Value('(@ElementGU)1', 'uniqueidentifier') = @SelectedValueGU I don't know how you want to select from your base table - whether you want to have a WHERE clause or something - but the CROSS APPLY basically takes the XML field and creates a "pseudo-table" called AED. Element from the nodes given in the XPath expression, and cross-applies those to the base table. So now, for each entry in Control and each Element node in those rows, you get one row of data In that row, you can now pick out those rows where the ElementGU value corresponds to the value you passed in, and for those XML nodes where this is the case, you then select the value of the Label attribute.

You need to approach this a bit differently: since you have a list of nodes, I would suggest you create a list of nodes and then pick the right one from that list - something like this: SELECT AED.Element. Value('(@Label)1', 'varchar(100)') as ControlLabel FROM Control CROSS APPLY Control_XML. Nodes('/AEDControl/Elements/Element') AS AED(Element) WHERE AED.Element.

Value('(@ElementGU)1', 'uniqueidentifier') = @SelectedValueGU I don't know how you want to select from your base table - whether you want to have a WHERE clause or something - but the CROSS APPLY basically takes the XML field and creates a "pseudo-table" called AED. Element from the nodes given in the XPath expression, and cross-applies those to the base table. So now, for each entry in Control and each node in those rows, you get one row of data.In that row, you can now pick out those rows where the @ElementGU value corresponds to the value you passed in, and for those XML nodes where this is the case, you then select the value of the @Label attribute.

I think this XPath (with sql:variable() extension function) should work: /AEDControl /Elements /Element@ElementGU = sql:variable("@SelectedValueGU") /@Label.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.