fnGetRaisersEdgeRecordIDFromLinkedUserID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@UserID	int	IN

Definition

Copy



        CREATE FUNCTION [dbo].[fnGetRaisersEdgeRecordIDFromLinkedUserID](@UserID int)
              RETURNS int AS 
              BEGIN
                 DECLARE @RaisersEdgeRecordID  int
                   select  TOP 1 @RaisersEdgeRecordID = bosp.BackofficeRecordID
                    from dbo.BackOfficeSystemPeople bosp
                    inner join dbo.BackOfficeSystemUsers bosu on bosp.ID = bosu.BackofficePeopleID and bosu.[current] = 1
                    inner join dbo.ClientUsers u on bosu.ClientUsersID = u.ID
                    where u.ID = @UserID and bosp.BackOfficeSystemID = 0
                    return @RaisersEdgeRecordID
              END