copying row from same table and adding value from form.request

[ll]

I'm working on a way to copy most data columns from another row in the
same table to a new row and insert the courseID value from the form
that executes this action (the copy). Is it possible to have both
"values" and "select" in the same Insert Into statement?
Here's what I have (below). The "CopyCourse ID" is the id of the
course that is copied to the new row, although the new row will have a
different course ID ("CourseID") .
---------------------------------------------------------------

strCourseID=Req uest.Form("Cour seID")
Insert table_a(CourseI D,Name,Address)
Values(strCours eID)
Select Name, Address
From table_a
Where Course ID = Request.Form("C opyCourseID")
------------------------------------------------------------------

Thanks,
Louis

[Roy Harvey (SQL Server MVP)]

Re: copying row from same table and adding value from form.request

You can simply include the value in the SELECT list. A simplified
version, using constants, though you would use values from your
application.

INSERT table_a(CourseI D,Name,Address)
SELECT 1234, Name, Address
FROM table_a
WHERE Course ID = 5678

Roy Harvey
Beacon Falls, CT

On Mon, 12 May 2008 12:38:51 -0700 (PDT), ll <barn104_1999@y ahoo.com>
wrote:

>I'm working on a way to copy most data columns from another row in the
>same table to a new row and insert the courseID value from the form
>that executes this action (the copy). Is it possible to have both
>"values" and "select" in the same Insert Into statement?
>Here's what I have (below). The "CopyCourse ID" is the id of the
>course that is copied to the new row, although the new row will have a
>different course ID ("CourseID") .
>---------------------------------------------------------------
>
>strCourseID=Re quest.Form("Cou rseID")
>Insert table_a(CourseI D,Name,Address)
>Values(strCour seID)
>Select Name, Address
>From table_a
>Where Course ID = Request.Form("C opyCourseID")
>------------------------------------------------------------------
>
>Thanks,
>Louis

[ll]

Re: copying row from same table and adding value from form.request

On May 12, 3:27 pm, "Roy Harvey (SQL Server MVP)"
<roy_har...@sne t.netwrote:

You can simply include the value in the SELECT list. A simplified
version, using constants, though you would use values from your
application.
>
INSERT table_a(CourseI D,Name,Address)
SELECT 1234, Name, Address
FROM table_a
WHERE Course ID = 5678
>
Roy Harvey
Beacon Falls, CT
>
On Mon, 12 May 2008 12:38:51 -0700 (PDT), ll <barn104_1...@y ahoo.com>
wrote:
>

I'm working on a way to copy most data columns from another row in the
same table to a new row and insert the courseID value from the form
that executes this action (the copy). Is it possible to have both
"values" and "select" in the same Insert Into statement?
Here's what I have (below). The "CopyCourse ID" is the id of the
course that is copied to the new row, although the new row will have a
different course ID ("CourseID") .
---------------------------------------------------------------

>

strCourseID=Req uest.Form("Cour seID")
Insert table_a(CourseI D,Name,Address)
Values(strCours eID)
Select Name, Address
From table_a
Where Course ID = Request.Form("C opyCourseID")
------------------------------------------------------------------

>

Thanks,
Louis

Thanks so much! This worked great.
Much appreciated,
Louis