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]
