Solved

Help needed in stored proc

Posted on 2011-02-25
3
308 Views
Last Modified: 2012-05-11
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_ItemTotalPrice ) from the select statement.

how to implement this in the attached stored proc



I need to build the reports based on this


reportdetailcost.txt
0
Comment
Question by:sqlcurious
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 24

Expert Comment

by:mankowitz
ID: 34982788
1. your procedure is mssql, not mysql
2. I don't know what you are trying to do. Are you trying to rewrite the query so that it calculates markup?
0
 

Accepted Solution

by:
sqlcurious earned 0 total points
ID: 34983277
yes i am trying to rewrite it can u help >it is SQl server
0
 

Author Closing Comment

by:sqlcurious
ID: 35308420
no reply so closing
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question