Its say now this.

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'case'.

I have change a little bit (select and from statement) And the '0000' (in crystal) that the numbers must begin from 0 1 2 3 and if it line down its 0 #0 if it is the then 10.. Its weird i know.. 🙂