I have a sql database I want to generate a report which is I am suplying date rage in there year is not taken for rane query is below
SELECT COUNT(*) AS Expr1
FROM WHIRE_Candidate
WHERE (UploadStatus = 1) AND (CONVERT(char(10), KeyedDate, 101) BETWEEN '06/01/2005' AND...