Ramblings of a DBA

Tara Kizer
posts - 166, comments - 835, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

September 2003 Blog Posts

My gripe today

I have been asked to look into why a stored procedure is failing.  The problem is that the application gets an error that a temp table doesn't exist.  Here is the code with the problem (my comments in blue, contents were changed to protect company information):        FETCH NEXT FROM @cursor         INTO @ID, @Name                IF @@FETCH_STATUS <> 0  This doesn't make sense, nor does the next WHILE statement.  It says if there are records in the cursor (which is SELECT * FROM a temp table), drop the temp table, get rid of the cursor, raise an error that something couldn't be found.  BUT IT...

posted @ Tuesday, September 30, 2003 12:18 PM | Feedback (1) | Filed Under [ Gripes ]

My first blog post

This is my first post.  Hopefully I'll have some good information to post here soon.

posted @ Sunday, September 28, 2003 1:42 AM | Feedback (0) | Filed Under [ Other ]

Powered by:
Powered By Subtext Powered By ASP.NET