spGetClientUserIDs

Parameters

Parameter	Parameter Type	Mode
@ClientsID	int	IN
@Deleted	bit	IN
@Active	bit	IN
@UserImportID	int	IN

Definition

Copy



        CREATE PROCEDURE [dbo].[spGetClientUserIDs] (
            @ClientsID  int,
            @Deleted    bit,
            @Active        bit,
            @UserImportID int
        )
        AS

        set nocount on
        if (@UserImportID>0)
            select 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

        else
            select [id] from dbo.clientusers 
            where [ClientsID] = @ClientsID and [Deleted] = @Deleted AND [active]=@Active