Dear Experts
Sqlserver Table1holds data as follows
date---------------sno
01/01/2010-------1
01/01/2010-------2
01/01/2010-------4
01/01/2010-------5
01/01/2010-------7
02/01/2010-------1
02/01/2010-------2
02/01/2010-------6
02/01/2010-------8
How to findout missed sno in 01/01/2010?
I want to get this result
3
6
Please help