Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: SQL Mapping Products

  1. 06-14-2011, 12:57 PM #1
    joecalardo is offline Member
    Join Date
    May 2011
    Posts
    61

    Default SQL Mapping Products

    I have about 400 products that don't have mapping currently, I have their product ID's and the Category ID's they should be going into. What is the correct query to run to insert these products into these categories. Thanks!
  2. 06-14-2011, 04:47 PM #2
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    INSERT INTO ProductCategory (ProductID,CategoryID) VALUES (123,456);


    The above would insert product id 123 into category id 456.



    TTFN

    BFG
    Blog - Random Blurb from BFG 9000
    Twitter - @BFG9000
  3. 06-15-2011, 03:24 PM #3
    mikemurphy is offline Senior Member
    Join Date
    Mar 2006
    Location
    United Kingdom
    Posts
    207

    Default

    We gave up and bought this - it's just a mare of a job otherwise !

    http://www.ecommercecartmods.com/p-1...torefront.aspx
    8.0.1.4 W2008R2 64-bit MSSQL2005