USP_DATAFORMTEMPLATE_VIEW_SPONSORSHIPPROGRAMINFO

create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SPONSORSHIPPROGRAMINFO (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @SPONSORSHIPOPPORTUNITYGROUPID uniqueidentifier = null output,
    @AMOUNT money = null output,
    @ISAFFILIATE bit = null output,
    @BASECURRENCYID uniqueidentifier = null output
)
as
set nocount on;
-- be sure to set this, in case the select returns no rows

set @DATALOADED = 0;

  select 
      @DATALOADED = 1,
      @SPONSORSHIPOPPORTUNITYGROUPID = SPONSORSHIPPROGRAM.SPONSORSHIPOPPORTUNITYGROUPID,
      @AMOUNT = SPONSORSHIPPROGRAM.AMOUNT,
      @ISAFFILIATE = case when SPONSORSHIPAFFILIATEPROGRAM.ID is not null then 1 else 0 end,
      @BASECURRENCYID = SPONSORSHIPPROGRAM.BASECURRENCYID
  from dbo.SPONSORSHIPPROGRAM
  left outer join dbo.SPONSORSHIPAFFILIATEPROGRAM on SPONSORSHIPAFFILIATEPROGRAM.ID = SPONSORSHIPPROGRAM.ID
  where SPONSORSHIPPROGRAM.ID = @ID

  return 0