To Insert datas in a table by selecting from another table use the following method

The following example explains how to select and insert data from one table to other.

Insert INTO T_UserTimeDetail (FK_UID_UserID,DTD_TimeIn)
(
Select PK_UID_UserID,'9/1/2008 11:38:21 AM' from dbo.T_UserMaster
)