CODEWITHSUNDEEP
sqlsql-serversql-server-2008
cc0
cc0

Reputation: 1950

How to insert row for each unique value found in column

How could I, in SQL Server 2008, write a SQL statement that would insert one row for each distinct value it finds in one column in the same table?

Edit:
The table I want to add rows to the same table I'm checking.

I have normalized table with a column [Name], and [Hobby], so how do I insert one new hobby for each name?

Input greatly appreciated =]

Upvotes: 0

Views: 3175

Answers (2)

Yahia
Yahia

Reputation: 70369

try

INSERT INTO TargetTable (SomeColumn)
SELECT DISTINCT TheSourceColumn From SomeSourceTable;

IF that is not what you are looking for please provide more details like what the data model looks like etc.

UPDATE - after edit from OP:

I am not sure that you data model is good but you can do this:

INSERT INTO TheTable (NAME, HOBBY)
SELECT DISTINCT X.NAME, @SomeHOBBY FROM TheTable X;

Upvotes: 2

ASetty
ASetty

Reputation: 114

You could use something like

Insert into table1
Select distinct col1 from tabl2

The above should work as long as table1 has just one column of the same data type as col1 of tabl2

Upvotes: 0

Related Questions