fnGetSupervisorId

                CREATE function [dbo].[fnGetSupervisorId]()
                returns integer 
                as
                begin
                    declare @Id integer
                    select @Id = ID from dbo.ClientUsers 
                    where UserName = 'supervisor'
                    and ClientsId = 1
                    if @@rowcount = 0 
                    select @Id=min(ID) from dbo.clientusers 
                    where issupervisor = 1 and deleted = 0

                    return @Id
                end