spCustomFormEntry_Summary

      CREATE PROCEDURE [dbo].[spCustomFormEntry_Summary]
          (
          @ClientSitesID int,
      @FormID int = -1,
      @UserID int = -1
      )
      AS
        SELECT FormID, Title, 
        SUM(CASE WHEN EntryState = 1 THEN 1 ELSE 0 END) AS NumStarted, 
        SUM(CASE WHEN EntryState = 2 AND AttributeType = 2 THEN 1 ELSE 0 END) AS NumCompleted 
        FROM dbo.vwCustomFormEntries
        Where @ClientSitesID = ClientSitesID AND (@FormID = -1 or ID = @FormID) AND (@UserID = -1 or OwnerID = @UserID)
        Group By Title, FormID