Need Help! SQL Query to pull product feed from DB

Discussion in 'Databases' started by mike2016, Jan 20, 2010.

  1. #1
    I'm trying to pull the product feed info from our database so we can submit them to the price comparision sites, but i'm facing one issue.

    our accounting system runs on MS SQL, we have seperate price levels for different type of customers. there are

    MSRP
    Internet Price
    Wholesale Lv1
    Wholesale Lv2

    but only the MSRP price exists in the SQL tables, the later 3 price levels are calculated on the fly, depending on the % discount we set in the system. The discounted prices on shown on the website and our backend sales entry screen.

    I was able to pull everything EXCEPT the calculated prices.

    Any idea how this can be done?
     
    mike2016, Jan 20, 2010 IP