adding multiple values using insert query

Question

hi guys plz help i have one table of employee registration containing fields like s_nolevelname ...etc i have completed the registration the values for level column will be 123....20. but now i have to give some award every month to these employees and for that i have another table where i have s_nomonthyearamount now i just want to select all the s_no from 1st table and belonging to the respective level and assign some money to every employee belonging to respective level. for example i have a dropdownlist containing levels 1 to 20 when admin will select the levelfor example 1 at that moment i will select all the s_no belongs to level 1 now the main work and the admin will enter the amount fir level one in a textbox now i want to insert all s_no's of level 1 with amount in another table plz tell me how to do this

John Penn · Answer

You can use a SELECT statement as the source of the data for an INSERT as in this example: USE AdventureWorks2008R2; GO CREATE TABLE MySalesReason ( SalesReasonID int NOT NULL Name nvarchar(50) ModifiedDate datetime); GO INSERT INTO MySalesReason SELECT SalesReasonID Name ModifiedDate FROM AdventureWorks2008R2.Sales.SalesReason WHERE ReasonType = N'Marketing'; GO SELECT SalesReasonID Name ModifiedDate FROM MySalesReason; GO http://msdn.microsoft.com/en-us/library/ms189872.aspx