Passing a Dynamic Query to a cursor

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  February 26, 2004 at 2:10 am

  #107433

  Hi,

   

  I am wondering if there is any way where a string variable can be passed to a cursor instead of a select statement like

   

  DECLARE @sql_str VARCHAR(255)

  SET @sql_str='SELECT * FROM EMP'

  DECLARE myEmp CURSOR FOR  @sql_str

   

  Is there any way where in I can accomplish the above requirement of passing a dynamic sql to a cursor.

   

  Any help would be highly appreciated.

   

  Thanks

  -Prasad

   

   

   

   

   

  Prasad Bhogadi
  www.inforaise.com

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 26, 2004 at 2:13 am

  #495766

  Put the whole statement into your string and execute it dynamically as explained here http://www.sommarskog.se/dynamic_sql.html#cursor

  

   

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]