Make a copy of parts of a ROW, but with a new Key.

[Robin Tucker]

Hi there,

I want to insert a new record into my database table, giving new field
values for all but one (an image field), which I can copied from an existing
record. The background to this is that I am allowing a user to create a new
"template" from an existing one, thus I want a new record, but also to copy
the existing template data blob into the new record.

My code looks like this, but obviously doesn't work (I don't supply a field
for the first field "ID" in my SELECT statement which should be a unique ID.
Obviously, I want SQL to automatically generate one for me!). Is there any
way to do this with SQL?

IF @Error = 0
BEGIN
SELECT @DateCreated,
@Title,
@Description,
@Thumbnail,
ReportTemplate.Report

INTO

ReportTemplate

FROM

ReportTemplate

SET @Error = @@ERROR
END

[Robin Tucker]

I think I got it. Like this:

IF @Error = 0
BEGIN
INSERT INTO
ReportTemplate
(
DateCreated,
Title,
Description,
IsStatic,
Thumbnail,
Report
)

SELECT

@DateCreated,
@Title,
@Description,
@IsStatic,
@Thumbnail,
ReportTemplate.Report

FROM

ReportTemplate

WHERE

ReportTemplate.ID = @ID

SET @Error = @@ERROR
END

"Robin Tucker" <id*************************@reallyidont.com> wrote in
message news:c6*******************@news.demon.co.uk...

Hi there,

I want to insert a new record into my database table, giving new field
values for all but one (an image field), which I can copied from an existing record. The background to this is that I am allowing a user to create a new "template" from an existing one, thus I want a new record, but also to copy the existing template data blob into the new record.

My code looks like this, but obviously doesn't work (I don't supply a field for the first field "ID" in my SELECT statement which should be a unique ID. Obviously, I want SQL to automatically generate one for me!). Is there any way to do this with SQL?

IF @Error = 0
BEGIN
SELECT @DateCreated,
@Title,
@Description,
@Thumbnail,
ReportTemplate.Report

INTO

ReportTemplate

FROM

ReportTemplate

SET @Error = @@ERROR
END