Home Forums SQL Server 2008 T-SQL (SS2K8) SQL Query to select one row and fill missing columns from another matching row. RE: SQL Query to select one row and fill missing columns from another matching row.

  • October 2, 2012 at 4:45 am

    #1544293

    Thanks laurie and dwain.c.

    dwain.c i like your approach as it's bit simple but please can you give some explanation so that it makes more sense to me... i always thought that max() function is used for numbers...

    did a quick test and both of them seem to work but unfortunately I can't use SQL 2008, sorry didn't mention this earlier.

    Regards,

    kk