hi everyone,

My problem is I want to increment a calculated column

from a program in the stored procedure

as an example

@ans=(qty}*{price}

have tried

@ans+=1 to no avail

also if the total cost is not a calculated column

and i wanted to calulate the total cost in a routine from stored procedure what would be the procedure….sorry but i am new to

openinisght

hoping somone can help

debbie

Debbie,

i am new to openinisght

Welcome to the party!

My problem is I want to increment a calculated column from a program in the stored procedure

I don't really understand what you are trying to accomplish. If you could describe in general what you are doing I might be able to help you better.

i wanted to calulate the total cost in a routine from stored procedure what would be the procedure

Just declare your stored procedure in the calculated columns script area, like so:

Declare subroutine My_Stored_Procedure

Unless, of course, it's actually a function in which case it would look like this:

Declare function My_Stored_Procedure

Then call your stored procedure as you would normally with the proper arguments and whatever variable holds the final results that you wants just assigned it to @ANS:

@ANS=Results

dbakke@srpcs.com

SRP Computer Solutions

View this thread on the forum...