spSolicitorSolicitors
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SolicitorID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spSolicitorSolicitors
(
@SolicitorID int
)
AS
SELECT [ID],
[BackOfficeID] ,
[ClientUsersID] ,
[FundRaiserID] ,
[TeamID] ,
[ReportsToID] ,
dbo.fnFundRaiserPageID([ID],1) [FundRaiserPageID],
[Goal] ,
[RecruiterID] ,
[Inactive] ,
[Dirty],
[AthonUnits],
[AthonLocked]
FROM FundRaiserSolicitors WHERE ReportsToID = @SolicitorID
RETURN