Download
100% FREE
Office Document APIs for .NET
Online: 1354
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Bookmarks
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
Sql Server
>
Loading ...
user defined function for calculating cost * products
Posted by
Parthibansk
under
Sql Server
on 8/14/2012 |
Points: 10
| Views : 881 | Status :
[Member]
| Replies : 2
Write New Post
|
Search Forums
|
Resolved Posts
|
Un Answered Posts
|
Forums Home
i want 2 calculate products price.. by input cost * no of units and display in textbox
Reply
|
Reply with Attachment
Alert Moderator
Responses
Posted by:
San.Pblr.Gct
on: 8/14/2012
[Member]
Starter
|
Points: 25
0
Why do you want user defined function?ANy specific reasons?
If you have both the columns in same table, then
Select UnitPrice,NoOfProducts,(UnitPrice*NoOfProducts) as TotalPrice from tbl_Temp
Parthibansk
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Posted by:
Muhsinathk
on: 9/4/2012
[Member]
Bronze
|
Points: 25
0
Hi
Please execute this query
1) If UnitPrice and NoOfProducts are in same table
Select UnitPrice,NoOfProducts,(UnitPrice*NoOfProducts) as TotalPrice from table_name
2) If UnitPrice and NoOfProducts are in different table
Select T1.UnitPrice,T2.NoOfProducts,(T1.UnitPrice*T2.NoOfProducts) as TotalPrice from table1 T1 join Table2 T2 on T1.ID=T2.ID
Parthibansk
, if this helps please
login
to
Mark As Answer
. |
Alert Moderator
Login to post response
Latest Posts
Dial Hotmail Customer service Number +1-800-518-0963
(0)
New
Best Assignment Help Services Provider
(0)
Updated
How can a video in the website explain the navbar values?
(1)
Updated
surge arresters price
(0)
New
small hot chamber die casting machine for sale
(0)
New
Hangzhou Lin'an Tianfu non-woven
(0)
New
low price hook and loop buckle strap
(0)
New
preschool books suppliers
(0)
New
More ...