CASE statment in Computed Column Specification
Posted on 2009-06-27
I have an MS SQL database(SQL SERVER 2005). I have two columns I want to add together and have no problem doing this in the Computed Column properties with the following.
([itemHandlingPer] + [itemShippingPer])
Now, what if I only want them to add up IF [columnA] = Whatever
I figured I would have to use CASE or something, but I am so new to MS SQL that I cannot seem to figure it out.