Very Computer

I tried using a cursor and fetch to iterate through a result set, parse the
varchar string and update the record, but got an error stating:

<eb1>Number of results grid generated reached the maximum
limit. The maximum limit is 1,500.</eb1>

There must be a better way. Is using a cursor not the way to do this? How
should this task be accomplished? Many TIA.

The batch file is:

DECLARE myCursor CURSOR
FOR SELECT gldebitacct FROM dbo.LABTRANS WHERE gldebitacct LIKE '%1032'
FOR UPDATE OF gldebitacct
OPEN myCursor
FETCH NEXT FROM myCursor

    BEGIN

            BEGIN
            {Statement block}
            FETCH NEXT FROM myCursor
            END
    END
DEALLOCATE myCursor

--
Neill Laney
http://home.nc.rr.com/nlaney
--

Usually when one defines a cursor, one also defines local variables to hold
the values returned from the cursor. I notice that you are not defining any
local variables, nor is your FETCH assigning the data to local variables. A
FETCH without local variables just returns the data to the user, which is
usually not particularly useful.

The SQL Server Books Online section "DECLARE CURSOR" contains examples that
use cursors that you might want to review.

Aside from that, if I understand your requirement, there is no reason to use
a cursor in the first place. It sounds as if what you really what is
something closer to:

update dbo.LABTRANS
  set {column_name} = replace ( {column_name, '1234', '5678' )
where {column_name} like '%1234%'

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

Quote:> There must be a better way. Is using a cursor not the way to do this? How
> should this task be accomplished? Many TIA.

   UPDATE tbl
   SET    col = replace(col, '1234', '5678')
   WHERE  col LIKE '%1234%'

Although I have a nagging feeling that there is whole lot things you
haven't told us about. For instance which version of SQL Server you
are using.

--
Erland Sommarskog, SQL Server MVP

Books Online (updated!) for SQL 2000 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp