Skip to content

Instantly share code, notes, and snippets.

@caseydentinger

caseydentinger/gist:5356484

Created April 10, 2013 17:06
Show Gist options
  • Save caseydentinger/5356484 to your computer and use it in GitHub Desktop.
Save caseydentinger/5356484 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
, (CAST(products.products_physical_quantity AS signed) - products.quantity_on_orders) AS virtual_quantity
, MAX(virtual_quantity, 0) AS inbox_quantity
, MAX(virtual_quantity * -1, 0) AS backorder_quantity
, products.products_physical_quantity AS physical_quantity
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment