spDonationDesignations

                CREATE   PROCEDURE [dbo].[spDonationDesignations]
                (
                    @ClientDonationsID int
                )
                AS
                    SELECT 
                        ID, ClientDonationsID, BackOfficeID, Name, IsDefault, BackOfficeIDGUID, DisplayOrder  
                    FROM dbo.DonationDesignations where ClientDonationsID = @ClientDonationsID 
                    ORDER BY DisplayOrder
                    RETURN