How to check duplication of employee Id in the following Stored Procedure which is passed as an strxml file?

See more:

VS2005

C#2.0

C#

Visual-Studio

, +

How to check duplication of employee Id in the following Stored Procedure which is passed as an strxml file?

/************************************************************
Module : C3PSPS
Author : Alexander
Date : Feb 13,2014
Name : ODSAVE_CREDIT_DEBIT_ADJUST
Description : Save OD Credit Debit Details into ODCREDITDEBIT Table
Parameters :

Tables : ODCREDITDEBIT
Associated PL/SQLs :
Warnings :
See Also :

************************************************************/

alter PROCEDURE [dbo].[0DSAVE_CREDIT_DEBIT_ADJUST]
(
@p_strXML NTEXT ,
@p_error_code INT OUTPUT,
@p_error_msg VARCHAR(1000) OUTPUT
)
AS
BEGIN
SET NOCOUNT ON

DECLARE @loc_error_code VARCHAR(40)
DECLARE @loc_error_msg VARCHAR(1000)
DECLARE @idoc INT
DECLARE @error VARCHAR(40)



/*Parse XML String*/
EXEC sp_xml_preparedocument @idoc OUTPUT, @p_strXML
IF @@ERROR <> 0 Goto ERROR_HANDLER_XML

--Insert records in to Table
INSERT
INTO
ODCREDITDEBIT
(

CorporateId,
EmpId,
AccountNo,
CardNo,
CurrentRecordStatus,
MonthId,
Months,
Years,
ModeId,
Mode,
Amount,
Reason,

CreatedBy,
CreatedDate,
ModifiedBy,
ModifiedDate,
EODProcessedDate
)
SELECT
COMPANYID,
EMPLOYEEID,

ACCOUNTNO,
CARDNO,
CURRENTRECORDSTATUS,
MONTHID,
MONTHS,
YEARS,

MODEID,
MODE,

AMOUNT ,
REASON,
CREATEDBY,
CREATEDDATE,
MODIFIEDBY,
MODIFIEDDATE,
EODPROCESSEDDATE

FROM OPENXML (@idoc, '/XML/ROWINFO', 2) WITH
(

COMPANYID VARCHAR(50),
EMPLOYEEID VARCHAR(50),
ACCOUNTNO VARCHAR(20),
CARDNO BIGINT,
CURRENTRECORDSTATUS VARCHAR(1),
MONTHID INT,
MONTHS varchar(20),
YEARS INT,

MODEID VARCHAR(1),
MODE VARCHAR(50),
AMOUNT NUMERIC(18,2),


REASON VARCHAR(200),
CREATEDBY VARCHAR(20),
CREATEDDATE datetime,
MODIFIEDBY VARCHAR(20),
MODIFIEDDATE datetime,
EODPROCESSEDDATE datetime
)
XMLItems

END

EXEC sp_xml_removedocument @idoc
SET @error= @@error
IF @error <> 0 GOTO ERROR_HANDLER
Set @p_error_msg = ''
Set @p_error_code='0'
Return(0)

ERROR_HANDLER:
Set @p_error_msg = 'Procedure Name : ODSAVE_CREDIT_DEBIT_ADJUST. System Error.' + RTRIM(convert(char(6),@error))
Set @p_error_code = '-1'
Return(-1)

ERROR_HANDLER_XML:
EXEC sp_xml_removedocument @idoc
SET @p_error_msg = 'Procedure Name : ODSAVE_CREDIT_DEBIT_ADJUST. System Error. XML Error'
SET @p_error_code = '-1'
Return(-1)