Hello Sir..
I am working in asp.net technology with sqlserver 2008. I want to design database for quantity and price for any product . Please define how can we calculate price when we select one or more quantity of any product?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravinkumar BirajdarPosted May 15, 2014, 11:25 PM
select ProductID,ProductName,Qty,Price,Qty*Price As Amount from MST_Products
Jignesh TrivediPosted May 15, 2014, 11:39 PM
Sorry I am not getting you question.
you want auto calculated filed? --> we can use computed column in sql server
Is there any formula to calculate total price?