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 |
|
chakravorty.sanjay
Starting Member
1 Post |
 Posted - 2007-04-05 : 02:59:13
|
| hello,i have problem in sql server i have a table like thiscol1 col2---------------sanjay 100sanjay 200sanjay 300raj 200raj 600raj 500i want to display this table like thissanjay raj----------------100 200200 600300 500how to get this solution ...plz send the soluton |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-05 : 03:29:12
|
Do this in your front end. It is much easier to do it over there.
KH |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-04-05 : 03:59:13
|
quote:
Originally posted by khtan
Do this in your front end. It is much easier to do it over there.
KH
I appreciate your "Do it in front end" replies  MadhivananFailing to plan is Planning to fail |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-05 : 04:01:39
|
quote:
Originally posted by madhivanan
quote:
Originally posted by khtan
Do this in your front end. It is much easier to do it over there.
KH
I appreciate your "Do it in front end" replies MadhivananFailing to plan is Planning to fail
 Is it copyrighted ?
KH |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-04-05 : 04:02:49
|
| Also check these links for more info:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81079&SearchTerms=cross-tab[/url][url]http://weblogs.sqlteam.com/jeffs/archive/2005/05.aspx[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-04-05 : 04:15:56
|
| <<Is it copyrighted ?>>Not yet MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
display row as column header in sqlserver 2000