find out missing date in sql server

Question

i have a table like as student. m having data from 31/06/2009 till 06/08/2015 where i always put the records of all the students on daily basis so now i want to find out the dates in which i haven't added the data in student table.

Upendra Pratap Shahi · Answer

DECLARE @s DATE = '20150418'  @e DATE = '20150708' ; SELECT c . d  ID = COALESCE ( s . ID  0 ) FROM ( SELECT TOP ( DATEDIFF ( DAY  @s  @e )+ 1 ) DATEADD ( DAY  ROW_NUMBER () OVER ( ORDER BY number )- 1  @s ) FROM [master] . dbo . spt_values WHERE [type] = N'P' ORDER BY number ) AS c ( d ) LEFT OUTER JOIN [dbo] . [PhotograperRegistration] AS s ON c . d = s . Profile_CreatedDT WHERE c . d >= @s AND c . d DATEADD ( DAY  1  @e );

ravi rawat · Answer

hello sir i want a sql query to find the answer

Upendra Pratap Shahi · Answer

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

Rohan Gupta · Answer

Hello ravi please go through this link https://rmanimaran.wordpress.com/2008/07/04/getting-missing-date-values-in-sql-server/