Home Forums SQL Server 2005 T-SQL (SS2K5) Using the recordset from SELECT statement in an INSERT statement, all in one Stored Procedure RE: Using the recordset from SELECT statement in an INSERT statement, all in one Stored Procedure

  • March 27, 2008 at 5:23 am

    #794517

    Something like this:

    INSERT INTO LOGLOG (destination, [content])

    SELECT phonenumber, 'hello world'

    FROM USERLIST

    where OWNERNAME LIKE @name

    John