I found the answer to my problem. It turns out I can do this in one simple sql statement.

INSERT INTO Courses ([coursecategorynumber], [coursenumber], [coursetitle], [coursedescription],...

I am running SQL2K and I am using an INSTEAD OF trigger to handle an INSERT INTO a View. What I want is the view to act just like...