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 |
|
karthikeyan.marlen
Starting Member
16 Posts |
 Posted - 2011-11-25 : 06:00:00
|
| HiI am having a table like ECA(extra curricular)ID Name ECA marks1 aa cricket 1001 aa yoga 902 bb yoga 892 bb football 902 bb medit 78and i want to view this table asID Name ECA1 mark1 ECA2 mark2 ECA3 mark31 aa cricket 100 yoga 90 - -2 bb yoga 89 football 90 medit 78Pls provide me a solution for this,thanks in advancekarthikeyan |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
sql-programmers
Posting Yak Master
190 Posts |
|
|
|
|
|
pivot format (more rows in a single row)