How to use a select query inside an insert query in SQL Server 2005

Question

I need to insert values into a table. But my condition is that I need to select Min(date) from another table and this value should be inserted into another table.

My query

Insert into tempTable values
('Value1','Value2','Value3',(select min(val_dt) from anotherTable),'Y',getdate())

If I use this query I am facing error.

Guide me how to use select query inside the insert query.

rikitikitik · Accepted Answer · 2012-01-31 05:37:40Z

7

Instead of using VALUES() in the INSERT statement, use a SELECT to add the row values:

INSERT INTO tempTable
SELECT 'Value1', 'Value2', 'Value3', MIN(val_dt), 'Y', GETDATE()
FROM anotherTable

And the SELECT statement can be as convoluted as you want, meaning WHEREs and the like can be included.

answered Jan 31, 2012 at 5:37

rikitikitik

2,4802 gold badges28 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

How to use a select query inside an insert query in SQL Server 2005

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