Rich,
Can you do a :
INSERT INTO TableName (columnlist)
SELECT columnlist FROM TableName etc....
??
This assumes that you're using @identify/autonumber/blah
Stephen
----- Original Message -----
From: "Rich Wild" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 04, 2003 11:23 AM
Subject: [ cf-dev ] OT: SQL: copying text columns
> Hi all,
>
> I have a Stored Procedure that copies rows in a SQL 7 database back into
the
> same table, but with a different primary key, so that a user can quickly
> clone and edit records in an application. This SP uses cursors to achieve
> this (as we discussed on this list a while back)
>
> This works fine, but now one of the columns that needs to be copies is of
> the TEXT datatype, which can't be set to a local variable. So this means I
> can't do this:
>
> DECLARE @group_name VARCHAR(250), @group_description TEXT
> DECLARE groupCursor CURSOR
> LOCAL
> FOR
> SELECT group_name, group_description
> FROM groups
> WHERE group_id = @oldgroup
>
> OPEN groupCursor
> FETCH NEXT FROM groupCursor INTO @group_name,@group_description
> WHILE @@FETCH_STATUS = 0
> BEGIN
> INSERT INTO groups(group_name, group_description)
> VALUES(@group_name,@group_description)
> FETCH NEXT FROM groupCursor INTO @group_name,@group_description
> END
> CLOSE groupCursor
> DEALLOCATE groupCursor
>
>
> Can anyone think of another way to do this?
>
> ta.
>
>
> -------------------------------------------------------
> Rich Wild
> Senior Web Developer
>
> -------------------------------------------------------
> e-mango Tel: 01202 755 300
> Gild House Fax: 01202 755 301
> 74 Norwich Avenue West
> Bournemouth Mailto:[EMAIL PROTECTED]
> BH2 6AW, UK http://www.e-mango.com
> -------------------------------------------------------
> This message may contain information which is legally
> privileged and/or confidential. If you are not the
> intended recipient, you are hereby notified that any
> unauthorised disclosure, copying, distribution or use
> of this information is strictly prohibited. Such
> notification notwithstanding, any comments, opinions,
> information or conclusions expressed in this message
> are those of the originator, not of e-mango.com ltd,
> unless otherwise explicitly and independently indicated
> by an authorised representative of e-mango.com ltd.
> -------------------------------------------------------
>
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
