sqlcurious
asked on
Help needed in stored proc
Markup:
(Total bid price- sum of total costs -total base freight)/sum of total costs *100
here
Total bid price= sum (QI.QuoteItemQuantity * QI.QuoteItem_ItemTotalPric e ) from the select statement.
how to implement this in the attached stored proc
I need to build the reports based on this
reportdetailcost.txt
(Total bid price- sum of total costs -total base freight)/sum of total costs *100
here
Total bid price= sum (QI.QuoteItemQuantity * QI.QuoteItem_ItemTotalPric
how to implement this in the attached stored proc
I need to build the reports based on this
reportdetailcost.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no reply so closing
2. I don't know what you are trying to do. Are you trying to rewrite the query so that it calculates markup?