Below is the solution :

SET DATEFORMAT DMY;

--===== Conditionally drop the test table to make reruns easier

IF OBJECT_ID('TempDB..#Emp_Attendance','U') IS NOT NULL

...

Thanks a lot experts, problem solved through your valuable advice.

Yes, you were correct as it does not meet my requirements fully..

i think i have to use cursor for my query wherein i have to filter and fetch the data...

Empid Date P A

300 01/12/2010 ...

I'm using SQL Server 2000 !

Thanks a lot for the reply. This will work for me.

🙂