CREATE Procedure Usp_Charity_Get_ByFedID ( @FederationID int ) As Begin SELECT C.CharityNumber, ISNULL(C.OldCharityNumber,0), S.[State], C.Name, dbo.Fun_Charity_Activity(CF.CharityID) FROM PledgeNet.Charity AS C INNER JOIN PledgeNet.[State] AS S ON C.StateID = S.StateID INNER JOIN PledgeNet.CharityFederation AS CF ON C.CharityID = CF.CharityID Where CF.FederationID=@FederationID END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)