Advertisement
Guest User

Untitled

a guest
Apr 19th, 2014
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. SET @rn=1;
  2. SELECT
  3. '' AS `Price`, /* A */
  4. p.weight AS `Weight`, /* B */
  5. p.cost AS `Cost`, /* C */
  6. CONCAT('=IFERROR(ROUND(A', @rn, ' - C', @rn, '), 2), 0)') AS `Profit $`, /* D */
  7. CONCAT('=IFERROR((D', @rn, '/C', @rn, ')*100, 0)') AS `Profit %`, /* E */
  8. @rn:=@rn+1 AS `Row`
  9. FROM
  10. products p
  11. WHERE
  12. p.avail > 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement