I need to do an update statement where 3 columns are multiplied together and stored into another column. I'm not quite sure how to accomplish this.
UPDATE tblRequestHistory SET strPrintCost = (SUM(CONVERT(numeric(8, 4), strPrintCost) * intPages * intCopies)) WHERE strPrintCost IS NOT NULL
intPages and intCopies are stored in the tblRequestHistory. strPrintCost is also in the table and has a cost already assigned to it. I need to multiply these 3 fields together and overwrite the sum to strPrintCost.