USP_DATALIST_FAFDEFAULTSOCIALNETWORKSHARINGCONFIG

CREATE procedure dbo.USP_DATALIST_FAFDEFAULTSOCIALNETWORKSHARINGCONFIG(@EVENTID uniqueidentifier)
as
    set nocount on;

  declare @ID int

  select  SNP.ID as ID,
       SNP.TRANSACTIONTYPECODE as TYPECODE, 
        case SNP.TRANSACTIONTYPECODE
          when 0 then 'Donor'
          when 1 then 'Participant' 
          when 2 then 'Participant' 
          when 3 then 'Participant' 
          when 4 then 'Participant' 
          when 5 then 'Participant' 
          when 6 then 'Participant' end
          as TYPE,
        case SNP.TRANSACTIONTYPECODE
          when 0 then 'Donor to the event or to a participant'
          when 1 then 'Individual'
          when 2 then 'Team member'
          when 3 then 'Team leader'
          when 4 then 'Household member'
          when 5 then 'Household leader'
          when 6 then 'Company leader' end
          as ROLE
  from dbo.FAFEVENTSOCIALNETWORKPROPERTY SNP
  where EVENTID = @EVENTID and SNP.TRANSACTIONTYPECODE in (0,1,2,3,4,5,6)