spFundRaiserAddressBookContactsByTeamID
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TeamID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spFundRaiserAddressBookContactsByTeamID
(@TeamID int)
AS
SELECT
Contact.id
FROM
dbo.AddressBookContacts Contact
inner join dbo.ClientUsers cUser on cUser.EMail = Contact.Email
inner join dbo.FundRaiserSolicitors Solicitor on Solicitor.ClientUsersID = cUser.ID
left join dbo.FundRaiserTeams Team on Team.ID = Solicitor.TeamID
WHERE
Team.ID = @TeamID