insert into @Education
select T.Item.query ('./ID') .value ('.', 'int')
, T.Item.query ('./FromDate') .value ('.', 'date')
, T.Item.query ('./ToDate') .value ('.', 'date')
, T.Item.query ('./TitleOfQualification') .value ('.', 'nvarchar(100)')
, T.Item.query ('./OrganisationProvidingEducation') .value ('.', 'nvarchar(100)')
, dbo.uf_replace_to_null(T.Item.query ('./City_ID') .value ('.', 'int'))
, dbo.uf_replace_to_null(T.Item.query ('./Country_ID') .value ('.', 'int'))
, T.Item.query ('./__action') .value ('.', 'nvarchar(20)')
from @xmlInput.nodes ('/SQLP/P/data/dataelement/EDU/HREducation') as T(Item)
constraint CHECK_DATE CHECK (FromDate < ToDate and FromDate<=GETDATE() and ToDate <= GETDATE());