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 - 2002-03-18 : 09:57:58
|
| Sekhar writes "We have an application which bulk copies a file from mainframe to the SQL server every day (say with the name TABLE). In order to have the archive of every day we have a script that copies every day's table to another dynamically created table which is named as TABLE_MMDDYY. The problem that we face here is, if we have two files sent to us on the same day, we loose the first copy. Coulld you please help !!! (is there any way I can create a table with the time stamp as an extention like TABLE_MMDDYYHHMM???" |
|
|
Jay99
468 Posts |
Posted - 2002-03-18 : 11:02:08
|
| Whatever you are doing to create the table as TABLE_MMDDYY, just add HHMM . . . what's the problem?Jay |
 |
|
|
|
|
|
Script