Home Forums SQL Server 2008 T-SQL (SS2K8) Fill the column data with specific row value RE: Fill the column data with specific row value

  • August 28, 2012 at 10:14 am

    #1530928

    Let me clarify my question.

    PKCostCenterAmountAssignment Xfd1

    501002101250.00T0250076 100210

    501002101250.00T0250076 100210

    401002501250.00T0250076 100250

    401003701250.00T0250076 100370

    I want "100250" and "100370" (which is in CostCenter column in 3rd and 4th row) to be filled in place of 100210( which is in Xfd1 column in 1st and 2nd row)