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 |
|
sanchita
Starting Member
3 Posts |
 Posted - 2008-03-07 : 11:00:51
|
| i want to convert the rows of one table to be the column of another table in run time......i have two tables one having student id and name and in another table there are student id, marks and subject as english. hindi and maths in rows...i want to make another a third table which contains student id , name , marks as english, hindi, maths as the column....tried a lot but didnt get the right way...do we have to do it through Join or is there some other technique by which we can solve the query........i dont know wheather i am really informative or not..but am sitting online if incase you wanna know something else even.......... |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-07 : 11:01:42
|
PIVOT Operater in Books online.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
sanchita
Starting Member
3 Posts |
Posted - 2008-03-07 : 11:11:27
|
| am i really informative and had explained the exact query to the experts...please help me out.....its really urgent........... |
|
|
|
sanchita
Starting Member
3 Posts |
Posted - 2008-03-07 : 11:17:59
|
| Am sitting online and am looking for a positive response and help from the experts and user of the forum....atleast i can get a way to start....if anyone can please |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-07 : 15:22:16
|
How can you expect us to provide an answer?Just because it is urgent for you doesn't mean we have to jump through hoops to create sample data, sample tables and sample output.What have you actually tried? do you have anything that returns the records needed?What is the table structure? sample data? desired results of sample data?Sitting here staring at the forum whining about why no one will do all the work for you, simply won't get you anywhere toward your goal. After all you waited a full 10 minutes before whining that no one helped you.We volunteer our time here, and we have our own jobs to complete as well.... Be patient. Without a lot more information, look into the Help/Books on Line for the PIVOT operator.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
wanna convert rows of a table as columns