sql - Incorrect syntax near the keyword 'FROM' in my query -

sql - Incorrect syntax near the keyword 'FROM' in my query -

select dbo.scrcalcr$.agingdays, dbo.scrcalcr$.endingcount, dbo.scrcalcr$.priority, dbo.scrcalcr$.tpduns, score=( case when dbo.scrcalcr$.agingdays >= 150 case when dbo.scrcalcr$.endingcount >= 150 ((10 * dbo.scrcalcr$.endingcount) + (15 * dbo.scrcalcr$.agingdays))/ (dbo.scrcalcr$.priority * 0.1) * 1 else((10 * dbo.scrcalcr$.endingcount) + (15 * dbo.scrcalcr$.agingdays))/ (dbo.scrcalcr$.priority * 0.1) * 0.1 end else 0 end dbo.scrcalcr$ order score desc go

i getting error as:

msg 156, level 15, state 1, line 12

incorrect syntax near keyword 'from'.

i'm missing right paranthesis of: score=(.

so should work:

select dbo.scrcalcr$.agingdays, dbo.scrcalcr$.endingcount, dbo.scrcalcr$.priority, dbo.scrcalcr$.tpduns, score=( case when dbo.scrcalcr$.agingdays >= 150 case when dbo.scrcalcr$.endingcount >= 150 ( ( 10 * dbo.scrcalcr$.endingcount ) + ( 15 * dbo.scrcalcr$.agingdays ) ) / ( dbo.scrcalcr$.priority * 0.1 ) * 1 else( ( 10 * dbo.scrcalcr$.endingcount ) + ( 15 * dbo.scrcalcr$.agingdays ) ) / ( dbo.scrcalcr$.priority * 0.1 ) * 0.1 end else 0 end ) dbo.scrcalcr$ order score desc

sql sql-server sql-server-2008