spGetRESysRecordIDsFromUserImport
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientsID | int | IN | |
| @Deleted | bit | IN | |
| @Active | bit | IN | |
| @UserImportID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spGetRESysRecordIDsFromUserImport] (
@ClientsID int,
@Deleted bit,
@Active bit,
@UserImportID int
)
AS
set nocount on
if (@UserImportID>0)
select dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(CU.[id]) from dbo.clientusers CU
inner join dbo.UserImportMasterList ml on CU.id=ml.clientUsersID
where CU.[ClientsID] = @ClientsID and CU.[Deleted] = @Deleted AND CU.[active]=@Active and
ml.UserImportID=@UserImportID and ml.[Status] =0