USP_REVENUE_GETDATAFORPAGE

Stored proc to retrieve data needed for a revenue CLR page

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



        create procedure dbo.USP_REVENUE_GETDATAFORPAGE
        (
            @REVENUEID uniqueidentifier
        )
        as
            set nocount on;

            select
                PAYMENTMETHODCODE
            from
                dbo.REVENUE
            where
                ID = @REVENUEID;

            return 0;