I want to populate a table by another one (which will get truncate after), however when I used this it's only a ONE shot because SQL says that the table exist already. I just want to add rows into that Alberta table.

```
USE [DATAWAREHOUSE]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER Procedure [dbo].[prcAlberta] As 

(
Select *
INTO AlbertaData_Storing
FROM dbo.AlbertaData_import
where name is not null )

truncate table AlbertaData_import
GO

```