Something along these lines may help...
Code:CREATE VIEW v_NLT (id, cutofftm) AS SELECT id, CASE WHEN id > 13 AND id < 16 THEN '3:00pm' WHEN id = 16 THEN '1:00pm' WHEN id > 16 AND id < 21 THEN '12:00pm' WHEN id = 21 THEN '9:00am' WHEN id = 22 THEN '2:40pm' ELSE 'u/i' END FROM #totals GROUP BY id; UPDATE #totals SET t.cutoff = v.cutofftm FROM #totals AS t, v_NLT AS v WHERE t.id = v.id




Reply With Quote