very very big problem

Question

Dear friends I have one table having columns date and serial no. I want to generate sr no when date changes.its datatypes are datetime and int in sql server. and i am sending parameter through date time picker