Error 'input string invalid error' in SQL Server

Hi mann,

I have crossed checked with your procedure its working properly at my end so please check it and below is your procedure

SQL

CREATE PROCEDURE Employees
@Action int=null,

@EAttendanceid int=null,

@Attendancedate datetime= null,

@Employeeid int = null,

@FromTime datetime= null,

@ToTime datetime= null,

@Totalhours float= null,

@return int=null output

--Insert

As

Begin

--declare @Action int=1,@EAttendanceid int=null,@Attendancedate datetime= getdate(),@Employeeid int = 3069,@FromTime datetime= '8:00 AM',@ToTime datetime= '6:00 PM',@Totalhours float= 8, @return int=null

if(@Action='1')

Begin

If exists(select * from TblEmployee where Employeeid=@Employeeid)
Begin
if not exists(select * from TblEmployeeAttendance where Employeeid=@Employeeid and convert(date,Attendancedate,103)=CONVERT(date,@Attendancedate,103))
Begin
Insert into TblEmployeeAttendance(Attendancedate,FromTime,ToTime,Employeeid,Totalhours)values(@Attendancedate,@FromTime,@ToTime,@Employeeid,@Totalhours)
End
else
Begin
set @return=2
End
End
else
Begin
set @return=1
End
End
End

Hope this works for you