user defined function for calculating cost * products

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

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