Me sigue dando error con esta consulta:
Código:
SELECT NUT_DATA.Nutr_Val, NUT_DATA.Num_Data_pts FROM NUT_DATA INNER JOIN NUTR_DEF ON NUT_DATA.Nutr_No = NUTR_DEF.Nutr_No WHERE NDB_No = 93601 AND NUTR_DEF.SR_Order IN(300, 800, 600)
ORDER BY case
when 300 then 1
when 800 then 2
when 600 then 3
end
Msg 4145, Level 15, State 1, Line 3
An expression of non-boolean type specified in a context where a condition is expected, near 'then'.