InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 13:37:36 GMT20http://www.sqlservercentral.com/Forums/Topic1372406-145-1.aspx[code="sql"]DECLARE @t TABLE(value VARCHAR(10),xml_1 XML)INSERT INTO @T(value,xml_1)VALUES('1+2','<root><s>1</s><s>2</s></root>'), ('3+4','<root><s>3</s><s>4</s></root>')SELECT value,x.r.value('.','INT') AS sFROM @tCROSS APPLY xml_1.nodes('/root/s') AS x(r)[/code]Mon, 15 Oct 2012 01:48:27 GMTMark-101232http://www.sqlservercentral.com/Forums/Topic1372406-145-1.aspxI have a table like below.value xml_11+2 <root><s>1</s><s>2</s></root>3+4 <root><s>3</s><s>4</s></root>I want to get the value like,1+2 11+2 23+4 33+4 4Can you guys please help me urgently?Sat, 13 Oct 2012 02:14:42 GMTMB-1081964