How to count date?

HI, in your script you are using count function which is aggregate function, to avoid the error you have to use group by cluase also.

DECLARE @temp AS TABLE(Staff_Id INT, From_Date DATE, To_Date DATE, Total_Days INT, Applied_Date DATE, STATUS NVARCHAR(6),inform_Type VARCHAR(64))

INSERT INTO @temp
        ( Staff_Id ,
          From_Date ,
          To_Date ,
          Total_Days ,
          Applied_Date ,
          STATUS ,
          inform_Type
        )
VALUES  ( 2086 , -- Staff_Id - int
          '2014-05-05' , -- From_Date - date
          '2014-05-11' , -- To_Date - date
          6 , -- Total_Days - int
          '2014-05-02' , -- Applied_Date - date
          N'A' , -- STATUS - nvarchar(6)
          'Prior'  -- inform_Type - varchar(64)
        ),
         ( 2086 , -- Staff_Id - int
          '2014-05-05' , -- From_Date - date
          '2014-05-06' , -- To_Date - date
          2 , -- Total_Days - int
          '2014-05-05' , -- Applied_Date - date
          N'A' , -- STATUS - nvarchar(6)
          'Late Leave'  -- inform_Type - varchar(64)
        )


SELECT count(Applied_Date),From_Date,Inform_Type, Total_Days from @temp
 where Staff_Id=2086
 and Status='A' 
 and  '2014-05-05'
 BETWEEN From_Date AND To_Date
 GROUP BY From_Date,Inform_Type,Total_Days