Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-26 : 20:14:11
|
Caroline writes "Is it possible, and how is it possible, to create a cursor in SQL 7 that allows the select statement to be variable eg.
I want to use a cursor to import data from one table in one database into another table in another database. The only problem is that the name of the table in the first database changes daily.
On 1st September :
eTable120000901 -> eTable2YYYYMMDD
On 2nd September :
eTable120000902 -> eTable2YYYYMMDD
How can this be done ?
Thanks
Caroline" |
|
|
|
|
|
SQL Cursor with variable Select statement