I've had some SQL experience, but only through a few classes in college. So I apologize for my lack of experience.
I have created a trigger that is set off every time a new item has been added to TableA.
The trigger then inserts 4 rows into TableB that contains two columns (item, task type).
Each row will have the same item, but with a different task type.
How can I do this with tSQL using a single select statement? Thanks in advance for the help.