CREATE TABLE Test1 (InspectionDate date, [Type] char(1), 
DueDate AS case when InspectionDate = '1/1/2012' and [type] = 'A' THEN dateadd(DD, 1, InspectionDate)
				when InspectionDate = '1/1/2012' and [type] = 'B' THEN dateadd(DD, 20, InspectionDate)
				ELSE InspectionDate end  )
--I need to update DueDate field(automatically??)with different date values depending on the values in InspectDate & Type fields.
INSERT INTO Test1(InspectionDate, Type) VALUES ('1/1/2012', 'A'), ('1/1/2012', 'B')
GO
SELECT * FROM Test1
GO
DROP TABLE Test1