spGetBulkAddUpdateBackOfficeUsersConflicts

Parameters

Parameter	Parameter Type	Mode
@ClientsId	int	IN
@BackOfficeSystemId	int	IN
@IncludeQuarantine	bit	IN
Definition

Copy


    CREATE  procedure [dbo].[spGetBulkAddUpdateBackOfficeUsersConflicts](
            @ClientsId                integer,
            @BackOfficeSystemId        integer,
            @IncludeQuarantine        bit
        )
        as
        begin
            if (@IncludeQuarantine = 1)
                Select 
                a.Id, 
                a.BackOfficeId, 
                a.UserName, 
                a.Password, 
                a.FirstName, 
                a.LastName, 
                    b.UserName 'NCUserName', 
                b.FirstName 'NCFirstName', 
                b.LastName 'NCLastName', 
                b.EMail 'NCEMail', 
                dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(b.Id) 'NCRE7RecordsId',
                    a.ErrMsg, 
                a.Quarantine
                from BackOfficeUserImportErrRecords a
                inner join ClientUsers b on b.Id = a.ClientUsersId
            else
                Select 
                a.Id, 
                a.BackOfficeId, 
                a.UserName, 
                a.Password, 
                a.FirstName, 
                a.LastName, 
                    b.UserName 'NCUserName', 
                b.FirstName 'NCFirstName', 
                b.LastName 'NCLastName', 
                b.EMail 'NCEMail', 
                dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(b.Id) 'NCRE7RecordsId',
                    a.ErrMsg, 
                a.Quarantine
                from BackOfficeUserImportErrRecords a
                inner join ClientUsers b on b.Id = a.ClientUsersId
                where a.Quarantine = 0
        end