There are syntax error in your SP Code. Try this for a hint
Create proc [dbo].[sp_ManpowerCollection_TEST]
(
@ATTFromDate datetime,
@ATTToDate datetime,
@Location nvarchar(50)
)
as
Begin
if(not exists select COUNT(*) from dbo.tblBacManpoweCollection where ATTdate between @ATTFromDate and @ATTToDate and Location=@Location)
begin
delete tblManpowerCollection where ATTdate between @ATTFromDate and @ATTToDate and Location=@Location
SELECT EmpCode, ATTdate, LineCode,LineName,DesigCode,Designation,CompanyName,UnitName,DeptName,SecName,InHour,
InMin,OutHour,OutMin,Location,Counter,TotalOTHour,DayFlag,ProcessTime FROM tblManpowerCollection WHERE ATTdate between @ATTFromDate and @ATTToDate and Location=@Location
end
end