Storing Records to a cursor

• Ramesh Kilputhur Sridharan

  Old Hand

  Points: 352

  More actions

  January 20, 2004 at 12:12 am

  #160401

  HI ALL,

  I have a stored procedure that returns a set od rows.(proc1)

  i have another store proc. in which i need to call the proc1 and i want to store the returned rows into a cursor how to do it?

  is it possibel to declare a cursor like

  DECLARE c1 CURSOR FOR

   

  thannks and regds

  ramesh

• David Burrows

  SSC Guru

  Points: 65143

  More actions

  January 20, 2004 at 6:46 am

  #490799

  You can only build a cursor using a SELECT statement.

  Use a temp table, e.g.

  CREATE TABLE #temp (col1, col2 ...)

  INSERT INTO #temp EXECUTE proc1

  DECLARE cursor_name CURSOR

  FOR SELECT col1, col2 ...

  FROM #temp

  etc.

  Far away is close at hand in the images of elsewhere.
  Anon.