Re: Recursive SQL Statment

i have table which is containing group,route,date.
I have data lik this.

1. group route date
a1 3 1/1/06
a1 35 1/1/06
a2 4 1/1/06

want to show data lik that
dates 1 2 3 4 5 6 7
---------------------------------------
a1 3,32 2
a2 4 1



data like that.

thanks in advance

rakesh