fnFundraiserGetDefaultPageID
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @FundraiserID | int | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnFundraiserGetDefaultPageID]
(
@FundraiserID int
)
RETURNS int
AS
BEGIN
RETURN
(
SELECT TOP 1 pc.SitePagesID FROM Fundraisers fr
INNER JOIN PageContent pc ON pc.SiteContentID = fr.SiteContentID
WHERE fr.ID = @FundraiserID
)
END