How Do Dynamically Declare A Cursor (Table name) 1

[MarkDicken]

Basically I want to SOFTCODE "tblTable1" below:-

Declare TableCursor Cursor
GLOBAL
DYNAMIC
For
Select Field1, Field2 from tblTable1

Any Ideas ???

Many Thanks In Advance ...

Regards

Mark Dicken
Dublin, Ireland

 

[rajeevnandanmishra]

Hi Mark,
You can create dyanamic sql to create the cursor. Something like this.
----------------------
Your procedure code
.
.
.

DECLARE @sql varchar(100)
SELECT @sql='DECLARE myCursor CURSOR FOR '+
'SELECT myColumn1, myColumn2,... FROM '+
@myTable
EXEC(@sql) --This statement will create the cursor
.
.
.
----------------------

So you can pass @myTable to your procedure.

I hope this will move you in right direction.

 

[MarkDicken]

Cheers ... It Worked

Regards

Mark Dicken