Declare a Cursor with dynamic from table name

[jonbrown]

I need to delare a cursor within a stored procedure, but do not know the name of some of the tables to be used in the query until run time.

I can get the table names into variables and can build the SQL Select statement into a string as required, however I cannot find out how to declare the cursor to use this string.

Any help would be much appreciated

Thanks

Jon.

 

[xcata]

Hi,

You may introduce the cursor definition is sql dynamic string too.
or you may construct a temporary stored procedure to do the job.



Hope this helps, xcata.