COMPUTED COLUMN SQL
Posted on 2011-10-13
I would like to know about computed column.
I try below code but failed :
"TotalLeftLeg SmallMoney DEFAULT 0," & _
"TotalRightLeg SmallMoney DEFAULT 0," & _
"TotalPaidLeftLeg (CASE WHEN TotalLeftLeg < TotalRightLeg THEN TotalLeftLeg ELSE 0 END)," & _
"TotalPaidRightLeg (CASE WHEN TotalRightLeg < TotalLeftLeg THEN TotalRightLeg ELSE 0 END)," & _
What's wrong with TotalPaidLeftLeg and TotalPaidRightLeg ?