/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
CREATE PROCEDURE InsertAccountFromXML(
    @sXML NTEXT
)
AS
begin transaction
    DECLARE @iDoc INT
    EXEC sp_xml_preparedocument @iDoc OUTPUT, @sXML
                       
INSERT INTO dbo.Account (CREATIONDATE,OPENBALANCE,LOGOUTCOUNT,BALANCE,ACCOUNTID,LASTLOGIN,LOGINCOUNT,PROFILE_USERID)
 
 SELECT CREATIONDATE,OPENBALANCE,LOGOUTCOUNT,BALANCE,ACCOUNTID,LASTLOGIN,LOGINCOUNT, PROFILE_USERID
    FROM OPENXML(@iDoc,'/Account/dbo.Account',2)
    WITH (	CREATIONDATE DateTime 'CREATIONDATE', 
			OPENBALANCE Decimal(12,2) 'OPENBALANCE', 
			LOGOUTCOUNT int 'LOGOUTCOUNT',
			BALANCE Decimal(12,2) 'BALANCE',
			ACCOUNTID int 'ACCOUNTID',
			LASTLOGIN DateTime 'LASTLOGIN',
			LOGINCOUNT int 'LOGINCOUNT',
			PROFILE_USERID varchar(250) 'PROFILE_USERID')
    
    DBCC CHECKIDENT ( 'ACCOUNT', RESEED, 100000000 );		
    commit;
    EXEC sp_xml_removedocument @iDoc;
RETURN
