SQL Query Not givan relevent result
SQL Query Not givan relevent result
(OP)
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 '09/30/2005') AND (UserId = '1')
hear i am getting 1000 count but if i change the query date range '08/01/1999' AND '09/30/2005'
count reduce why is that
thank you
hemantha
SELECT COUNT(*) AS Expr1
FROM WHIRE_Candidate
WHERE (UploadStatus = 1) AND (CONVERT(char(10), KeyedDate, 101) BETWEEN '06/01/2005' AND '09/30/2005') AND (UserId = '1')
hear i am getting 1000 count but if i change the query date range '08/01/1999' AND '09/30/2005'
count reduce why is that
thank you
hemantha





RE: SQL Query Not givan relevent result
08/01/2005 is August 01, 2005
There is less data from August to September than from June to September.