• INSERT INTO

    dbo.Logtable (AdditionalInfo)

    SELECT

    'Another Process with ID: ' + CAST(ID AS VARCHAR(25)) + ' is currently in use')

    FROM

    [CBH]

    WHERE

    [SID] = 2;

    INSERT INTO

    dbo.Logtable (AdditionalInfo)

    SELECT

    'Another Process with ID: ' + CAST(ID AS VARCHAR(25)) + ' is currently in use')

    FROM

    [PBH]

    WHERE

    [SID] = 2;

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]