based on your various recommendations i finally found a good workable solution without having to compromise that much with my early tsql code in the views. i stayed with my...

Sean Lange (3/22/2013)

---

julesbenone (3/22/2013)

---

Sean Lange (3/22/2013)

---

Since you just want a grid solution maybe something like this would work?

;with StateData as

(

select t1.*, ROW_NUMBER() over(partition by t1.STATE order by t1.city) as...

Sean Lange (3/22/2013)

---

Since you just want a grid solution maybe something like this would work?

;with StateData as

(

select t1.*, ROW_NUMBER() over(partition by t1.STATE order by t1.city) as RowNum

from #tempCityState...

@Wagner

Used this and it did work. i got exactly what i want ...

<asp:TemplateField HeaderText="City" ItemStyle-Width="5cm" HeaderStyle-ForeColor="Blue"

...

Thanks Wagner got your point as its turning to be an asp.net discussion i will try your code and find out if it can be of help

Thanks Lynn .. tried your CTE solution but it did not give the expected outcome .. i may concentrate on looking at a gridview templatefield solution.

Thanks Wagner i would appreciate if you can provide example of using gridview templatefield (with css) that will help to achieve new line feed carriage of below

City

----

Fremont,Hanford,Los Anggeles

Even do...

Tks for your adv Mark but i tried something quite the same without success .. below all options that i used so far

1)

Stuff

...

Thanks Sean ... yes its formatting and i do undertsand tsql is not the best approach for doing same but for technical reason i want to do it on the...

Tks. tried that before logging this post but it didn't work ...