fnUserInformationExists

Return

Return Type
tinyint

Parameters

Parameter	Parameter Type	Mode	Description
@ClientsID	int	IN
@UserName	nvarchar(100)	IN

Definition

Copy



    CREATE    FUNCTION dbo.fnUserInformationExists
(
    @ClientsID int,
    @UserName nvarchar(100)
)
RETURNS tinyint
AS
    BEGIN
        declare @ReturnStatus tinyint
        set @ReturnStatus=0
        /*     ReturnStatus = 0 'User doesn't exist for the provided UserName and Registration Number
                        = 1 'User exists - UserName already in use
        */

        IF LEN(@UserName) > 0 
        BEGIN
            IF EXISTS (SELECT TOP 1 ID FROM ClientUsers WHERE ClientsID=@ClientsID AND UserName=@UserName)
            BEGIN
                set @ReturnStatus=1
            END
        END

        RETURN @ReturnStatus
    END