SQL Xml datatype

gistfile1.sql

Declare @Sizings XML
Select @Sizings = N'<Sizings><SDLC>Early Stage Analysis</SDLC><Estimate>10</Estimate></Sizings><Sizings><SDLC>Approach and Sizing</SDLC><Estimate>100</Estimate></Sizings>'
 
select
    Estimate = a.b.value('Estimate[1]','numeric(18,6)')
   ,SDLC = a.b.value('SDLC[1]','nvarchar(500)')
from @Sizings.nodes('Sizings') a(b)


select convert(nvarchar(500),@Sizings.query('data(/Sizings/SDLC)') )