Home Forums SQL Server 7,2000 T-SQL Transpose Rows to columns based on key RE: Transpose Rows to columns based on key

  • Can't have an aggregate in an update statement. I'm trying to think if a self join with the inner join would work but I'm not getting it yet.

    Suggestions? Thanks!