Hi Friend,
create table tbl_Employee_payment(
Emp_id int foreign key references tbl_EmployeeMast(Emp_id),
paymentdate date,
Empl_name varchar(300),
designation varchar(100),
salary decimal(16,2),
advance_amnt decimal(16,2),
sale_of_month decimal(16,2),
bonus_amnt decimal(16,2),
payment_mode varchar(100),
payment_detail varchar(max),
payment_amnt decimal (16,3)
)
Change your decimal range to decimal(16,2) in all columns where you are using decimal datatype . hope this will help. thanks..