How to populate a temp table with a view using a stored procedure .. SQL Server

I have a view created in Sql Server 2008 that returns a set of rows..I have a table created that I want to hold the results from the view because I have to manipulate the data in there without having to change the original data..I also wanted to run a trigger on this temp table..

Can this be done from a stored procedure or do I have to write the code out in VB.Net which is the language I am using..

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

That actually seems to be working and I have a Insert trigger on the table as well which seems to be doing what it should after the rows are inserted..
This is a table that is going to be used quite alot... right now I have this as the SP....

I'd use truncate table instead of delete from.
It'll work much faster and will have a much smaller footprint as it doesn't log the deletes. You wouldn't want to engage transaction log specially if the table is going to have large number of rows.
Further more in the job/stored proc which will be responsible for populating the table, I would drop all indexes (if any) before the insert and create them again after insert is done, for two obvious reason:
1. Insert would be much faster without any indexes;
2. Deleting and then inserting large number of rows is guaranteed to result in badly fragmented indexes, recreating indexes after the insert ensures you'll have nice and tidy indexes to begin with, after every data refresh.

I didn't include the truncate statement for a purpose. Truncate requires the user who calls the proc to have either db_owner perms, or a user that owns the table. You can use EXECUTE AS, but the idea behind it is overkill.

Also, if by some happenstance another use ever calls the procedure, you're broken. That happens that way w/ the DELETE statement too...unless you use criteria.

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…