|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
March 1st, 2005, 08:44 PM
|
|||
|
|||
Convert multiple columns into one single column
Hi all,
i have a unique problem of displaying multiple column data into single column. The data looks like this country state India AP India Orissa India MP Pakistan Karachi Pakistan lahore into this single resultset Complete List ------------------ India AP Orissa MP pakistan Karachi lahore The reason behind this is to display as a menu in datagrid control in ASP.NET. Any help would be highly appreciated. Thanks (I want a query for this kind of generation)
|
|
#2
March 8th, 2005, 11:31 AM
|
|||
|
|||
|
Hey arnab_100!
I'm not really an expert on the field, but I think it can't be done with a simple select (maybe it can, I don't know for sure). I would use a SP with cursors...you process each country with a cursor and for each one, you select all the cities. Check on that...since you got no response.. Good Luck! Anibal.
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Convert multiple columns into one single column |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
