USP_DATALIST_SPONSORSHIPGETSMARTFIELDS

CREATE procedure dbo.USP_DATALIST_SPONSORSHIPGETSMARTFIELDS (
    @SPONSORSHIPOPPORTUNITYTYPECODE tinyint = 0
)
as
    set nocount on;

    select 
    SMARTFIELD.ID,
    SMARTFIELD.NAME 
  from dbo.SMARTFIELD 
  inner join dbo.SMARTFIELDCATALOG on SMARTFIELDCATALOG.ID = SMARTFIELD.SMARTFIELDCATALOGID
  inner join dbo.RECORDTYPE on RECORDTYPE.ID = SMARTFIELDCATALOG.RECORDTYPEID
  where SMARTFIELDCATALOG.PROCEDURENAME like '%SPONSORSHIP%'
  and (@SPONSORSHIPOPPORTUNITYTYPECODE = 0 or RECORDTYPE.NAME = case @SPONSORSHIPOPPORTUNITYTYPECODE when 1 then 'Sponsorship Opportunity Child' when 2 then 'Sponsorship Opportunity Project' end)