error while using subquery in insert operator

Question

I have table with the following structure:

FirstName|MiddleName|PatientID

I want in other table to store all distinct FirstNames. I have Created table named TBL and I want to insert into it all distinct FirstName rows. Let's assume first table name uis TBL1. I tried the following:

INSERT Into TBL(FirstName) VALUES (SELECT DISTINCT FirstName FROM TBL1)

But I've got error:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, ! =, <, <= , >, >= or when the subquery is used as an expression.

What am I missing here? I am talking about Microsoft Sql Server 2008 R2.

Oded · Accepted Answer · 2012-09-02 20:07:30Z

2

This should work just fine:

INSERT Into TBL(FirstName) 
SELECT DISTINCT FirstName FROM TBL1

VALUES is for the values in a single row.

answered Sep 2, 2012 at 20:07

Oded

501k102 gold badges900 silver badges1k bronze badges

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

Collectives™ on Stack Overflow

error while using subquery in insert operator

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related