stechsla
-
Posts
3 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by 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.
-
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!
Compute Values in the Same Table
in SQL
Posted