I have the following requirement for a computed column, based on the contents of another column in the same table. If the amount is less than 0, the value should be C otherwise it's value should be D.
I have used the following notation in the computed column specification;
CASE [monAmount] WHEN < 0 THEN 'C' ELSE 'D'
It will not validate. Why?
You should write the expression in this format:
CASE WHEN [monAmount] < 0 THEN 'C' ELSE 'D' END
and everything should be ok.
Richard, try this:
CREATE TABLE tempja
(colA INT IDENTITY(-2,1),
colB AS (CASE WHEN cola < 0 THEN 'C' ELSE 'D' end),
colC int)
run this 5 times:
INSERT INTO [dbo].[tempja]
( [colC] )
VALUES
(
1 -- colC - int
)
Also add the PERSISTED keyword to the column definition. It will remove the need to recalculate the formula over and over again, at the expense of some storage space.
1 Person is following this question.
