how to avoid existing date below in sql?

Question

I'n my sql 2012 im generating a series of current month date like below in grid    this is the query im using to generate a date ; WITH dates(Date) AS ( SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) as Date UNION ALL SELECT DATEADD(d,1,[Date]) FROM dates WHERE DATE ) Select * from ( select convert(varchar(max),DATE,105) as [AttDate] from master_table) as tt     date  2017-03-01 2017-03-02 2017-03-03 2017-03-04 2017-03-05  upto   2017-03-30 im inserting a date in one  sample table like below   date  2017-03-01  2017-03-03     once i insert a date in sample table i dont want to generate that date in grid how can i achieve that task my fina result is  2017-03-02 2017-03-04 2017-03-05 upto 2017-03-30

Answer

your question is not clear. can you please explain it in more details. thanks

siva nathan · Answer

Ramesh are you there?

Tapan Patel · Answer

I am not sure what do you mean by ' dont want to generate that date in grid ' , I believe it must be through some sort of UI.  But if you want to prevent it from happening at server level, then put a Primary Key contraint on that column to avoid duplication and handle the check in code.

Ramesh Palanivel · Answer

Hi Siva,   Sure Siva

siva nathan · Answer

if you have some free time you can come with teamviewer

Ramesh Palanivel · Answer

Hi SIva,   Extreamly sorry for that, My project is going End line.. I cannot take your machine!.. let me tryt the login and let you know

siva nathan · Answer

not in key word is not working i dont no why can u pls come with team viewer

Ramesh Palanivel · Answer

Hi Siva nathan,   Use "Not In"  method in your query!.. Read about that, It may help you!... Using that you can achieve your task!...