Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Multiplication of two colomns
jayakrishnan Morayur
Jul 22 2011 4:28 AM
1.4k
Reply
My table is bellow
productId productQty productRate
1 10 100
2 20 200
3 30 300
4 40 400
5 50 500
I want @qtyRate = productQty*
productRate
then sum the @qtyRate using sqlserver 2005
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Difference between SSIS,SSRS and SSAS
Product of two table feilds