|
Posted by Dranai on 02/18/06 22:33
Hmm...
I believe the answer to the question is "both". My friends needs to
store the results in the table as a new column, so that later queries
can access the data.
Your last paragraph has given me pause. Could using a computed column
from the query cause problems later on?
The query I was able to come up with is:
// ----- Query -----
add discquantity as ((cast(chrisslu.quantity as int)) *
cast(chrisslu.nr_of_disc as int))
// ----- End Query -----
And is returning "function name is missing )". Any thoughts on this?
I didn't believe that the query was related to any function call,
unless each query is considered a function call in MS SQL.
I definately believe we're getting close to a solution here.
Chris
Navigation:
[Reply to this message]
|