InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 18:24:40 GMT20http://www.sqlservercentral.com/Forums/Topic475307-338-1.aspxSomething like this:[code]INSERT INTO LOGLOG (destination, [content]) SELECT phonenumber, 'hello world' FROM USERLIST where OWNERNAME LIKE @name[/code]JohnThu, 27 Mar 2008 05:23:21 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic475307-338-1.aspxHi, i'm an SQL newbie. I'm trying to figure out if there's an easy way to take a single field record set from a SELECT statement and then do an INSERT using that record set, all in one single Stored Procedure.Here's what i tried to do, but this returns an error "The name "phonenumber" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.".The common field in both SELECT and INSERT is phonenumber.[quote]PROCEDURE [dbo].[usp_select_and_insert] @name varchar(20),ASSELECT [b]phonenumber[/b] FROM USERLIST where OWNERNAME LIKE @nameINSERT INTO LOGLOG (destination,content) values([b]phonenumber[/b],'hello world');GO[/quote]Hope that one of you can be kind enough to give me some guidance. Appreciate in advance. :)Thu, 27 Mar 2008 04:59:51 GMTjoshua__lim