Hi friends,
The data in the table
empid empname date status
1 name 25/06/2009 p
1 name 26/06/2009 p
1 name 27/06/2009 p
2 name 2 26/06/2009 p
2 name 2 27/06/2009 p
2 name 2 28/06/2009 p
3 name 3 27/06/2009 p
-
-
-
-
-
-
-
-
i want output like this
emp id emp name 25/06/2009 26/06/2009 27/06/2009 -
-
-
1 name p p p
2 name2 p p p
-
--- -
-
-
here dates i in date column is dynamic
Regards uday