• What exactly are you trying to accomplish? Delete any workstation ID's that dont exist in your table?

    If so ....

    DELETE FROM W

    FROM tbl_Workstations AS W

    LEFT JOIN @wksInPse AS pse

    ON W.WorkstationId = pse.WorkstationId

    WHERE pse.WorkstationID IS NULL

    If not, then we need more info.

    Future note, read the article in my signature, and you'll get more timely and accurate responses.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg