Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jackbee
Starting Member
5 Posts |
 Posted - 2007-03-12 : 06:10:18
|
| Dear everyone, i have a table like below:id title1 a2 b3 cand i want to get data from the table above with this format:column1 column2 column3 column41 a 2 b3 cHow can i do this with select statement or inner join?? or an posible way , please help me Thnks |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-03-12 : 09:14:06
|
| Hi, Can you give a bit of context to what you're trying to achieve. At first glance, it looks a bit odd!Mark |
 |
|
|
jackbee
Starting Member
5 Posts |
Posted - 2007-03-12 : 09:32:36
|
| I try to display data like "article column" in newspaper |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-12 : 21:28:22
|
Don't do this in T-SQL. Do it in your front end application instead.
KH |
|
|
|
|
|
|
select data by vertical dimension