USP_FUNDRAISERSOLICITORS_GETNEWIDS

create procedure dbo.USP_FUNDRAISERSOLICITORS_GETNEWIDS
(    
    @FundraiserID int
)
as
begin
    SELECT BackOfficeID FROM FundRaiserSolicitors WHERE FundRaiserID = @FundraiserID AND BackOfficeID > 0 AND IsSynced = 0
    UPDATE FundRaiserSolicitors SET IsSynced = 1 WHERE FundRaiserID = @FundraiserID AND BackOfficeID > 0 AND IsSynced = 0
end