How to count no of record for current date or current day ?

Hi Bhavesh,

You can achieve this if you have date column in your table, If you have date column then try this one,

SELECT  COUNT (ColumnNameTocount) as Total FROM YourTableName where CAST(YourDateCoumn AS DATE) = CAST(GETDATE()AS DATE)

Don't you have any date/datetime column?

https://stackoverflow.com/questions/9229862/how-to-count-number-of-records-per-day

SELECT COUNT(*) FROM 
mytable 
WHERE 'myfkid' = 1112 and datecolumnnamecreated, '%d-%m-%Y') = curdate();