USP_REVENUELIFECYCLECRITERIA_GETCRITERIA

CREATE procedure dbo.USP_REVENUELIFECYCLECRITERIA_GETCRITERIA
as
begin
    select top 1    
        ID,
        DONORPERIOD,
        DONORASOFDATE,
        MIDLEVELDONORGIFTAMOUNT,
        CONSIDERRECOGNITION,
        USECONSECUTIVELOYALYEARS,
        CONSECUTIVELOYALYEARS,
        USEMULTIPLELOYALYEARS,
        LOYALDONORMULTIYEARVALUE,
        LOYALDONORMULTIYEARRANGE,
        NOAFFINITYPERIOD,
        DONORFILTERTYPECODE, 
        USEMAJORDONORSINGLEGIFT,
        MAJORDONORSINGLEGIFTAMOUNT,
        USEMAJORDONORLIFETIMEGIVING,
        MAJORDONORLIFETIMEGIVINGAMOUNT,
        INCLUDEMAJORDONORPROSPECTS,
        PLANNEDGIFTMUSTHAVEPAYMENTS,
        TSLONG,
        (select top 1 ID from dbo.REVENUELIFECYCLEPROCESS) as BUSINESSPROCESSID
    from
        dbo.REVENUELIFECYCLECRITERIA
end