Situation is, I have a table which contains multiple records of a item but with different date. For example, I have table of workers which contains the Id, Name, WorkingDay column similar to below table: ID NAME WorkingDay 1 VJ 15-Mar-2012 2 AP 15-Mar-2012 3 TS 15-Mar-2012 1 VJ 16-Mar-2012 2 AP 17-Mar-2012 I want […]