Why do I get “A cursor with the name already exists”?

by

You are using global cursor that will be defined each time you are calling this procedure and give you the same error.

Define a local cursor. Just put the keyword LOCAL after CURSOR:

declare detailsCursor CURSOR LOCAL FOR
...

Related Contents:

  1. Can I loop through a table variable in T-SQL?
  2. Get Multiple Values in SQL Server Cursor
  3. SQL Server – Best way to get identity of inserted row?
  4. Should I use != or for not equal in T-SQL?
  5. Is it possible to specify condition in Count()?
  6. T-SQL Cast versus Convert
  7. How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?
  8. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  9. SQL RANK() versus ROW_NUMBER()
  10. When to use Common Table Expression (CTE)
  11. How do I create a foreign key in SQL Server?
  12. Changing the maximum length of a varchar column?
  13. Recover unsaved SQL query scripts
  14. Creating an index on a table variable
  15. How do I remove the first characters of a specific column in a table?
  16. How do you copy a record in a SQL table but swap out the unique id of the new row?
  17. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  18. Can I create a One-Time-Use Function in a Script or Stored Procedure?
  19. IDENTITY_INSERT is set to OFF – How to turn it ON?
  20. alternatives to REPLACE on a text or ntext datatype
  21. COALESCE Function in TSQL
  22. How to get current instance name from T-SQL
  23. SQL Row_Number() function in Where Clause
  24. How do you update a DateTime field in T-SQL?
  25. SELECT FOR UPDATE with SQL Server
  26. How to get the identity of an inserted row?
  27. How do I return the SQL data types from my query?
  28. How to find column names for all tables in all databases in SQL Server
  29. ROW_NUMBER Without ORDER BY
  30. Update records in table from CTE
  31. Truncate/Clear table variable in SQL Server 2008
  32. Syntax for INSERTing into a table with no values?
  33. Most efficient way in SQL Server to get date from date+time?
  34. Insert multiple values using INSERT INTO (SQL Server 2005)
  35. What is the equivalent of the Oracle “Dual” table in MS SqlServer?
  36. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  37. SQL Server: how to add new identity column and populate column with ids?
  38. How to get difference between two rows for a column field?
  39. Update if different/changed
  40. What is the difference between “;” and “GO” in T-SQL?
  41. What does =* mean?
  42. What’s the SQL national character (NCHAR) datatype really for?
  43. T-SQL: Selecting Column Based on MAX(Other Column)
  44. T-SQL split string based on delimiter
  45. DateTimeOffset.Now in T-SQL
  46. How can I INSERT data into two tables simultaneously in SQL Server?
  47. SQL: parse the first, middle and last name from a fullname field
  48. Sort by minimum value of two columns
  49. How to add a Try/Catch to SQL Stored Procedure
  50. MS SQL Date Only Without Time

Leave a Comment