• INSERT INTO db1.dbo.attendance_details(employee_no,date_of_attendance,present,shift_type,marked_by)

    SELECT employee_no,date_of_attendance,present,shift_type,marked_by

    FROM db2.dbo.attendance_details

    WHERE date_of_attendance IN ('2014-07-01','2014-07-02');

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP