CREATE PROCEDURE InsertOrdersFromXML(
    @sXML NTEXT
)
AS
begin transaction
    DECLARE @iDoc INT
    EXEC sp_xml_preparedocument @iDoc OUTPUT, @sXML
                       
INSERT INTO dbo.ORDERS (ORDERFEE,COMPLETIONDATE,ORDERTYPE,ORDERSTATUS,PRICE,QUANTITY,OPENDATE,ORDERID,ACCOUNT_ACCOUNTID,QUOTE_SYMBOL,HOLDING_HOLDINGID)
 
 SELECT ORDERFEE,COMPLETIONDATE,ORDERTYPE,ORDERSTATUS,PRICE,QUANTITY,OPENDATE,ORDERID,ACCOUNT_ACCOUNTID,QUOTE_SYMBOL,HOLDING_HOLDINGID
    FROM OPENXML(@iDoc,'/Orders/dbo.Orders',2)
    WITH (	ORDERFEE decimal(12,2) 'ORDERFEE', 
			COMPLETIONDATE DateTime 'COMPLETIONDATE', 
			ORDERTYPE varchar(250) 'ORDERTYPE', 
			ORDERSTATUS varchar(250) 'ORDERSTATUS',
			PRICE decimal(12,2) 'PRICE',
			QUANTITY float 'QUANTITY',
			OPENDATE DateTime 'OPENDATE',
			ORDERID int 'ORDERID',
			ACCOUNT_ACCOUNTID int 'ACCOUNT_ACCOUNTID',
			QUOTE_SYMBOL varchar(250) 'QUOTE_SYMBOL',
			HOLDING_HOLDINGID int 'HOLDING_HOLDINGID');
	
	DBCC CHECKIDENT ( 'ORDERS', RESEED, 100000000 );  
	commit;
    EXEC sp_xml_removedocument @iDoc;
RETURN