CREATE PROCEDURE InsertQuoteFromXML(
    @sXML NTEXT
)
AS
begin transaction
    DECLARE @iDoc INT
    EXEC sp_xml_preparedocument @iDoc OUTPUT, @sXML
                       
INSERT INTO dbo.QUOTE (LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1)
 
 SELECT LOW,OPEN1,VOLUME,PRICE,HIGH,COMPANYNAME,SYMBOL,CHANGE1
    FROM OPENXML(@iDoc,'/Quote/dbo.Quote',2)
    WITH (	LOW decimal(12,2) 'LOW', 
			OPEN1 decimal(12,2) 'OPEN1', 
			VOLUME float 'VOLUME', 
			PRICE decimal(12,2) 'PRICE',
			HIGH decimal(12,2) 'HIGH',
			COMPANYNAME varchar(250) 'COMPANYNAME',
			SYMBOL varchar(250) 'SYMBOL',
			CHANGE1 float 'CHANGE1');
	commit;
    EXEC sp_xml_removedocument @iDoc;
RETURN