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
Quote:
Originally Posted by praneethraj
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.
