[blueletter]

At work they have me working on a database. I have it all done except for a the last stored procedure. I need to be able to multiply to columns in the same table then returning that value to a third column. I am having trouble thinking of how to pull two values then returning the product to another field. I know there is no direct way to multiply values so there has to be a workaround that I have not thought of. I know its got to be simple but I cant seem to grasp the idea of simple procedures over the difficult ones. If you could give me a source or a outline of what the code will look like that would be much appreciated.

[baavgai]

I usually would lead you on and try to let you figure it out, but this one's too short not to be a gimme.

select col1, col2, col1*col2 as col3
   from table

Is this what you're looking for or am I missing something?

This post has been edited by baavgai: 09 May 2008 - 01:29 PM