• Hi SQL Guy,

    Please post a sample structure for the two tables with some sample data.

    This will help us determine what is wrong with the TSQL.

    Thanks

    John Miner
    Crafty DBA
    www.craftydba.com