Fetching data from xml content in SQL Server
DECLARE @ADDRESS_XML_STRING NVARCHAR(4000)
DECLARE @IDOC INT
Set @ADDRESS_XML_STRING= '<ADDRESS_INFORMATION><ADDRESS ADDRESS_TYPE="Current" ADDRESS_EFFECTIVE_START_DATE="2010-11-22" STREET1="7 Cherokee Rd" REGION1="Middlesex" REGION2="MA"...