USP_DATALIST_FAFEVENTFORMTEMPLATE

          CREATE procedure dbo.USP_DATALIST_FAFEVENTFORMTEMPLATE
      (
              @FORMCATEGORYCODE TINYINT
          ,@APEXFORMID uniqueidentifier = NULL
          ,@EVENTID uniqueidentifier = NULL
      )
      as
          set nocount on;

      SELECT 
           E.ID
          ,E.NAME
        ,AF.ID as FAFEVENTFORMTEMPLATEID
        ,AF.ID as FORMID
     from dbo.EVENT E 
      join dbo.EVENTEXTENSION EX on E.ID = EX.EVENTID
      join dbo.APEXFORM AF on EX.CLIENTSITESID = AF.SITEID
      join dbo.APEXFORMTYPE AFT on AFT.ID = AF.FORMTYPEID
      where 
      (
      (@FORMCATEGORYCODE=3 and AF.FORMTYPEID = '33BE06AD-F3EF-46C9-A002-3DD13790737E') 
      or (@FORMCATEGORYCODE=1 and AF.FORMTYPEID = '34C019D8-9CD0-4321-9778-09BD145A3E57') 
      or (@FORMCATEGORYCODE=2 and AF.FORMTYPEID = '59F07A4F-FE97-47D9-A197-B430E8BCBC1C')
      or (@FORMCATEGORYCODE=4 and AF.FORMTYPEID = '644EBCF1-15B1-4B24-AD45-AF1A63A9CBEE')
      or (@FORMCATEGORYCODE=5 and AF.FORMTYPEID = '714FB1BE-4A9D-4CA1-B819-8B5B562037A1')
      )
      and (EX.EVENTID = @EVENTID OR @EVENTID IS NULL)
      and (AF.ID = @APEXFORMID OR @APEXFORMID IS NULL)
      ORDER BY AF.DATEADDED