Accessing rows from within a stored procedure... ?

[adek]

Hi,

how can one access rows from a query from within the stored procedure?? The query is a dynamic one (because the DB-name is dynamic).
This does'nt apparently work:
declare @Var cursor for
execute sp_executesql @sql
open...

Like this (working version) for the static query:
declare @Var cursor for
select ID from dbo.Tbl
open ...

How can I make the upper version work?

Please help!!
//adek

 

[sunila7]

Hi,

u will have to do it some thing like this

declare @sql varchar(200)

set @SQL = 'Declare var cursor for SELECT * from table'
exec(@sql)
open var


Sunil