-- ColorCode-byLivingFlag.sql
/*
2015-01-25 Tom Holden ve3meo
Clears all colors
Sets Red if Living is true, Green if Living false
*/


BEGIN
;
-- Clear colorcoding
UPDATE PersonTable 
SET Color = 0
;
-- Set Living red
UPDATE PersonTable 
SET Color = 1
WHERE Living
;
-- Set NotLiving green
UPDATE PersonTable 
SET Color = 9
WHERE NOT Living
;
COMMIT
;