Home Forums SQL Server 7,2000 T-SQL record formating RE: record formating

  • June 26, 2003 at 6:44 am

    #463217

    Or

    select col1,

    col2,

    max(col3),

    max(col4),

    max(col5),

    max(col6)

    from tablename

    group by col1,col2

    to group by first 2 cols.

    Edited by - davidburrows on 06/26/2003 06:44:56 AM

    Far away is close at hand in the images of elsewhere.
    Anon.