My data is bellows::
Date Item_ID Item_Name Sales_Parson
19-Aug 1005 Mouse Shakir Hossain
19-Aug 1005 Mouse Shakir Hossain
19-Aug 1005 Mouse Kabir Khan
19-Aug 1008 Key Board Sibbir Ahmed
19-Aug 1008 Key Board Sibbir Ahmed
19-Aug 1008 Key Board Shakir Hossain
and I want to generate like this query::
Date Item_ID Item_Name Sales_Parsons_Name
19-Aug 1005 Mouse Shakir Hossain, Kabir Khan
19-Aug 1008 Key Board Sibbir Ahmed, Shakir Hossain
Please Help Me...!! I am in big big trouble....
anybody can help me...!!