USP_GET_CONSENTSOLICITCODE

CREATE procedure dbo.USP_GET_CONSENTSOLICITCODE
(
    @ID uniqueidentifier
)
as
    select top 1
      SOLICITCODE.ID AS SOLICITCODEID, 
        SOLICITCODE.DESCRIPTION AS CAPTION, 
        SOLICITCODE.ACTIVE, 
      case
        when SOLICITCODE.EXCLUSIONCODE = 2 then 1
        else 0 
      end as ISREQUIRED,
        SOLICITCODE.CONSENTCODE,
      SOLICITCODE.SOLICITCODECHANNELCODE AS CHANNEL,
        CASE 
            WHEN SOLICITCODE.SITEID IS NULL THEN 'All sites' 
            ELSE SITE.NAME
        END as SITENAME,
    SITE.ID as SITEID
    from  
      dbo.SOLICITCODE
      left join dbo.SITE on SOLICITCODE.SITEID=SITE.ID
    where 
          SOLICITCODE.ID=@ID