Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
3
Answers
Product of two table feilds
jayakrishnan Morayur
13y
1.8k
1
Reply
I have a table bellow
productId productQty productRate
1 10 100
2 20 200
3 30 300
4 40 400
5 50 500
i need the out put is bellow
productQty
-----------
(10*100)+
(20*200)+
(30*300)+
(40*400)+
(50*500)
in SQL Server 2005
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Multiplication of two colomns
Cannot open database requested by the login. the login failed