SQL SELECT INTO query with a Join, Error "There is already an object named '*****' in the database."

sql sql-server join select-into
James O Brien picture James O Brien · Jun 22, 2012 · Viewed 14.1k times · Source

I'm currently trying to copy data from table into another by using a SELECT INTO query. But Im receiving an error in SQL Server.

"Msg 2714, Level 16, State 6, Line 2 There is already an object named 'Product' in the database."

Im still very new to sql. This is the SQL script I've created to do the job. 

BEGIN TRANSACTION
SELECT d.[PDate]
      ,d.[SDate]
      ,d.[UseDRM]
      ,d.[CreatedBy]
      ,d.[CreatedDate]
      ,d.[UpdatedBy]
      ,d.[UpdatedDate]
INTO [******].[dbo].[Product]
FROM [******].[dbo].[ProductTypeData] AS d
JOIN [******].[dbo].[Product] AS t
ON d.ProductTypeDataID = t.ProductTypeDataID
ROLLBACK TRANSACTION

I have already created these column in the destination table but they are currently empty. Any help is greatly appreciated.

Answer

phillyd picture phillyd · Jun 22, 2012

SELECT INTO is used to create a table based on the data you have.

As you have already created the table, you want to use INSERT INTO.

E.g.

INSERT INTO table2 (co1, col2, col3)
SELECT col1, col2, col3
FROM table1

Related questions

SQL update from one Table to another based on a ID match

I have a database with account numbers and card numbers. I match these to a file to update any card numbers to the account number, so that I am only working with account numbers. I created a view linking the …

Read More
Difference between JOIN and INNER JOIN

Both these joins will give me the same results: SELECT * FROM table JOIN otherTable ON table.ID = otherTable.FK vs SELECT * FROM table INNER JOIN otherTable ON table.ID = otherTable.FK Is there any difference between the statements in performance …

Read More
Can I use CASE statement in a JOIN condition?

The following image is a part of Microsoft SQL Server 2008 R2 System Views. From the image we can see that the relationship between sys.partitions and sys.allocation_units depends on the value of sys.allocation_units.type. So to …

Read More