Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Insert into multiple rows

    Thanks everyone for your help...I think I was putting paraenthesis in by accident. The final code to do the trick was:

    INSERT INTO tblTraining(EMPID, CourseID, Status)

    SELECT EUID, 9750, 'NT'

    FROM...

    November 4, 2011 at 2:35 pm

    #1403506

  • RE: Insert into multiple rows

    I'm sorry, first time I've ever posted a help request.

    Ok so I have 3 tables:

    - a table of employee info (tblEmployee), like ID, firstname, lastname, department, etc.

    - a table of...

    November 4, 2011 at 1:45 pm

    #1403485

  • RE: Insert into multiple rows

    No those didnt work, just to clarify the 9750 and NT are actual values I am inserting into tblTraining for each of the employees in tblEmployee.

    November 4, 2011 at 12:04 pm

    #1403434

Viewing 3 posts - 1 through 3 (of 3 total)