insert query with select statement

Question

Hi I have one table: DId Description 1 desc1 2 desc2 I want insert Did in table2 based on description (means from front end I am inserting desc1 but in database table it should insert 1) second table : EId DId Name 1 1 name1 2 2 name2 I am using query with insert select statement but not working. so please help in query to get this result. Thanks

Ramesh Maruthi · Answer

Declare @Description Nvarchar(50) Insert Into Second table(Did ) Select Did from one table Where Description = @Description

Dipankar Biswas · Answer

Please send me your query... SQL INSERT INTO SELECT Examples INSERT INTO Customers (CustomerName Country) SELECT SupplierName Country FROM Suppliers; And INSERT INTO Customers (CustomerName Country) SELECT SupplierName Country FROM Suppliers WHERE Country='Germany';