To Find missing dates in data-gridview.

can you please send your tables detail.

thanks for reply but my dates and other information are not coming from single table. I am getting dates and other information by inner join 3-4 tables so your recommended links will not work. Like dates, reg_no from registration table then doctor name from doctor master table then patients details from patient table like this. My aim is to know absent dates of doctor in a particular period selected by to and from datetimepickers

Keyur Patel12y ago

Hi Alan,

You can use common table expression and pass your date range. Please refer following links to find missing dates in sql.

http://www.codeproject.com/Tips/328085/Find-Missed-Date-Ranges-using-SQL-Server

https://www.simple-talk.com/sql/t-sql-programming/find-missing-date-ranges-in-sql/

http://stackoverflow.com/questions/20677472/sql-find-missing-date-ranges

reg_date	dcotor_name	patient_name	reg_no	Kin_name
1/1/2014	rahul	manmohan	12534	sonia
3/1/2014	narendra	abc	54896	lalu
4/1/2014
10/1/2014