Date: 01/25/07 (SQL Server)    Keywords: no keywords

I have a table of scores that I need to query. There are multiple scores per row. The scores are stored numerically, but have a text equivalent stored in a separate table.

So my scores table has other fields as well as score fields with the scores stored numerically, for instance:
iReader1Score
iReader2Score
iReader3Score

My scoresText table has the text equivalent of the scores and an iReaderScore that matches with the iReaderXScores in the scores table:
iReaderScore
sScoreText

I need to extract the other data from the scores table as well as my scores displayed as their text equivalents.

Any help would be appreciated. Let me know if more information is required.

(x-posted)

Source: http://community.livejournal.com/sqlserver/55654.html