Home Forums SQL Server 2008 T-SQL (SS2K8) Cross Join Help RE: Cross Join Help

  • July 25, 2014 at 11:12 am

    #1732469

    dwilliscp (7/25/2014)

    I have a massive table (company, plant, resource, part number) that I need to create a from part number, to part number for every part within "Company, Plant, Resource" combo.

    Trying to figure out what the best method would be.. using a cursor will put the load on one CPU and take way too long.

    Ideas?

    Define "Massive" because that's important here. A "Control Cursor" (as opposed to RBAR) may be appropriate here.

    Also, I'd personally like to know what it is you mmean by "from" and "to" part numbers because it doesn't make sense to me to reference a toilet paper holder with hot water heater unless they're attached to each other and in the same bathroom.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)