By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,068 Members | 618 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,068 IT Pros & Developers. It's quick & easy.

converting rows into columns when the count is not known

P: 1
i have 2 rows with 3 columns each. ( each rows has a colun called ScoreType which contains different data like Performancelevel,scaledscore

Subject Marks ScoreType
A 2 Performancelevel
A 123 scaledscore
B 4 Performancelevel
B 678 scaledscore

i want this data as

Subject PerformanceLevel ScaledScore
A 123 2
B 678 4

how can i acheive this, Please not that the number of scoretypes is not constant, could be more also
Aug 21 '07 #1
Share this Question
Share on Google+
1 Reply

hariharanmca
100+
P: 1,977
i have 2 rows with 3 columns each. ( each rows has a colun called ScoreType which contains different data like Performancelevel,scaledscore

how can i acheive this, Please not that the number of scoretypes is not constant, could be more also
you didn't point your Database versions. anyway, you can use Cross Tab query.
Aug 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.