find out missing date in sql server

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);