I cant seem to get this right:

set @last = select case when @d < 1 then 0 else 1 end
-- 0 is sleep 1 is active

I am doing conditional processing in the cursor from hell <g>. I need to create a flag @last and set it 0 or 1 depending on the value of @D. What am I missing?

TIA

__Stephen