Mark-101232 (3/22/2013)

---

Maybe this?

Select Distinct State, (Select Stuff((Select '

' + City

From #tempCityState

Where State = t.State

FOR Xml Path(''),TYPE).value('.','VARCHAR(1000)'),1,1,'')) AS Cities

From #tempCityState t