Display Blank when column values are repeated

Jun 12 2012 7:59 AM
My stored proc out put is
Week         Name
1220        LOndon
1220        AUstralia
1221        London
1221        Singapore
1221        Zurich


But i dont want to repeat week again in columns. So i am expecting something like below
Week        Name
1220        London
               Australia
1221        London
               SIngapore
               Zurich

I dont want to do this in Excel, i just want to do it in Stored proc output. Can anybody help me??

Answers (2)