hi , im using a cursor in a sp,however ,when i declare it,the sp goes to catch block without throwing any error. @@fetch_status gives 0 at the starting of the sp ... is there some thing im missing
Sep 04 '12 at 12:34 AM
Feb 13 at 02:45 PM
Please share some code, it's hard to guess the possible reasons for your code to fail without having seen any of it...
my guess without seeing it, is that the sql query you are putting into the cursor returns no rows.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Sep 04 '12 at 12:34 AM
Seen: 376 times
Last Updated: Sep 20 '12 at 03:29 PM
how to get total no of months
Using a cursor and temporary table together
Difference between website and web application in .NET
How to display the output of a query in html form?
Sql Connect with java
Return recordset of ranges found in a list
SQL left outer join on two fields
Reporting Services BUILTIN\Administrator and how to get rid?
Group By syntax error - Incorrect syntax near the keyword 'Group'.
Identify all SSIS packages which have sql code using a database other than invoking a stored procedure
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.