Inserting values from sql query into a table column along with other data

Question

I have just created this table:

create table dbo.OrderTypes
(
ID smallint primary key identity,
Name varchar(300) not null,
CreatedOn datetime default getdate(),
CreatedBy nvarchar(300) not null,
ModifiedOn datetime default getdate(),
ModifiedBy nvarchar(300) not null
)

What I am trying to do is populate the Name field with results from this query:

select distinct ordertype from unit_results

as well as inserting CreatedBy and ModifiedBy by hand (they will be the same for every row).

How might I go about doing this?

I would suggest that you default the CreatedBy and ModifiedBy columns to something like system_user. Then you won't have to supply those values when a row is created. — Gordon Linoff
– Gordon Linoff, Commented Jul 5, 2012 at 21:19

SPFiredrake · Accepted Answer · 2012-07-05 20:09:21Z

2

INSERT INTO dbo.OrderTypes (Name, CreatedBy, ModifiedBy)
SELECT DISTINCT ordertype, 'CreatedBy Value Here', 'ModifiedBy Value Here'
FROM unit_results

answered Jul 5, 2012 at 20:09

SPFiredrake

3,89220 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Inserting values from sql query into a table column along with other data

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