[Solved] How to assign date at each insertion in sql server c# [closed]

by


Change your database structure like this 

Table Leave
emp_id,
leave_id,
leave_Type,
days_applied,
from_date,
to_date,
date_applied


Table Leave Type
leave_Type_id,
leave_Type

Note: Above tables are just for e.g. to solve your problem you can change it.

With above structure you can easily calculate leaves taken by employee and also filter by leave type.

5

solved How to assign date at each insertion in sql server c# [closed]