• Easy and straight-forward question.

    Thank you.

    And when I need to use something similar in MSSQL 2000 or 2005 I write this:

    INSERT INTO dbo.Table(Column1, Column2)

    SELECT 'Value1', 'Value2' UNION ALL

    SELECT 'Value3', 'Value4' UNION ALL

    SELECT 'Value5', 'Value6';

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA