Compute Values in the Same Table

[stechsla]

What I want to accomplish seems very simple, but I can't get figure it out. I have 2 columns in my table that I want to manipulate:ActualHoursEstimatedHoursI want to create a third column in the same table called PercentComplete, which is computed by ActualHours / EstimatedHours.I've only seem examples that create new tables. I haven't seen anything that allows me to compute values based on information in the same table.I know this seems so simple, and the solution probably is, but unfortunately I'm stumped. Any help would be greatly appreciated.Thanks!

[aspnetguy]

SELECT ActualHours, EstimatedHours, (ActualHours/EstimatedHours) AS PercentCompleteFROM TableName

That should work

[pulpfiction]

HiThis will create a new column, if this is what you need.....ALTER TABLE TablenameADD PercentComplete AS (ActualHours/EstimatedHours)

[aspnetguy]

I wasn;t sure what you want...do you want a third column when the query is displayed or do you actually want to add a 3rd column to the table?I would go with the third column on on display...why maintain a thrid column in hte table when it is just based on values the table already has.

[stechsla]

I wasn;t sure what you want...do you want a third column when the query is displayed or do you actually want to add a 3rd column to the table?I would go with the third column on on display...why maintain a thrid column in hte table when it is just based on values the table already has.

<{POST_SNAPBACK}>

[stechsla]

Worked like a charm.  Thanks everyone!  I really appreciate your help. 

<{POST_SNAPBACK}>