Hi,
Pls find the details.
Base Table:
CustomerIDGoodsPurschased Date
1001Ball20131210013618
1001Bat20131210020000
1002Tennis Bat20131210091055
1002Foot Ball20131210111130
1002Glouse20131210141015
1003Bat20131210081015
1004Tennis Ball20131210211015
1004Stump20131210151015
Expected Output:
CustomerIDGoodsPurschased Date
1001Ball2013-12-10 01:36:18.000
1002Tennis Bat2013-12-10 09:10:55.000
1003Bat2013-12-10 08:10:15.000
1004Stump2013-12-10 15:10:15.000