Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Insert multiple rows in a table with a single select statement RE: Insert multiple rows in a table with a single select statement

  • February 12, 2014 at 10:26 am

    #1688495

    I'm not sure why would you want that. It seems like a weird requirement.

    As you should know, triggers use 2 pseudo-tables (Inserted & Deleted) from which you need to get the information because you might not have it in the real table yet.

    You could use something like this.

    INSERT INTO TableB(item, tasktype)

    SELECT i.Item,

    t.tasktype

    FROM Inserted

    CROSS APPLY (VALUES('Planning'),('Design'),('Program'),('Production')) t(tasktype)

    If you have any questions on how it works, feel free to ask.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2