xml processing sp

 --CREATE TABLE XMML

--(XMLvAL VARCHAR(MAX))

alter PROC S_XMML 

@XMLDATA xml = null

AS

BEGIN

SELECT ParamValues.ID.query('MemberNo').value('.', 'VARCHAR(50)') AS MemberId

,ParamValues.ID.query('AccountNo').value('.', 'NVARCHAR(50)') AS LoanNo

,ParamValues.ID.query('PhoneNo').value('.', 'NVARCHAR(50)') AS PhoneNo 

,ParamValues.ID.query('EnrolledDate').value('.', 'date') AS EnrolledDate 

,ParamValues.ID.query('ExpiryDate').value('.', 'date') AS ExpiryDate 

,ParamValues.ID.query('Balance').value('.', 'money') AS Balance 

,ParamValues.ID.query('Charge').value('.', 'money') AS Charge 

into #TEMP1

FROM @XMLDATA.nodes('/DocumentElement/Temp') AS ParamValues(ID)

INSERT INTO XMML (XMLvAL)

SELECT MemberId FROM #TEMP1

SELECT 1 status,'data inserted sucessfully' msg

END