Add data from table to other Table SQLSERVER

Question

please i need your help i have two tables the first one is full with all calendar data dim_table_start(pk_date_deb,year,month,trimester,week,date) and i want to fill the second table with data from dim_data_start dim_table_end(pk_date_fin,year,month,trimester,week,date) i tried :

INSERT INTO [bd_disponibilite].[dbo].[dim_date_fin]
           ([PK_Date_fin]

           ,[Year]

           ,[Trimester]

           ,[Month]

           ,[Week]
        )
     VALUES
         (select * from dbo.dim_date_Debut)

but doesn't work

how can i add all data table to fill the second table thank you

Hart CO · Accepted Answer · 2013-07-18 17:06:17Z

3

You don't need the VALUES portion when inserting records using SELECT:

INSERT INTO [bd_disponibilite].[dbo].[dim_date_fin]
           ([PK_Date_fin]
           ,[Year]
           ,[Trimester]
           ,[Month]
           ,[Week]
           )
SELECT * 
FROM dbo.dim_date_Debut

answered Jul 18, 2013 at 17:06

Hart CO

34.9k6 gold badges52 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2586714 Over a year ago

Thank yo very much for help

Stainy Over a year ago

@Goat CO is correct. I'd just like to add some useful info. If you are only doing this insert once it's fine, but if you plan to re-use it I would be specific about the columns you are selecting instead of using Select *. It future proofs your code against somebody adding a column to the schema of dim_date_Debut, which would break your insert. I see this kind of bug a lot.

Eric Hauenstein · Accepted Answer · 2013-07-18 17:24:18Z

0

If the destination doesn't exist yet, you can also use SELECT * INTO dbo.dim_date_fin from dbo.dim_date_Debut

This is speedier to code because it copies the schema as well.

If the table exists or needs different properties, Goat's answer is better.

answered Jul 18, 2013 at 17:24

Eric Hauenstein

2,5656 gold badges35 silver badges43 bronze badges

Collectives™ on Stack Overflow

Add data from table to other Table SQLSERVER

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related