KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to select some fields from one table and insert them into an existing table from a stored procedure. Here is what I am trying: SELECT col1, col2 INTO dbo.TableTwo FROM dbo.TableOne WHERE col3 LIKE @search_key I think SELECT ... INTO ... is for temporary tables which is why I get an error that dbo.TableTwo already exists. How can I insert multiple rows from dbo.TableOne into dbo.TableTwo ?
Tags (comma-separated)
Save Edits
Cancel