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 |
|
wankhairul
Starting Member
1 Post |
 Posted - 2007-11-19 : 01:13:42
|
| I would like to seperate the data between years 2005 and 2006 from SQL 2000 database.And i also want to access those seperate data from the client pc through ODBC.Is it possible. |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-19 : 14:26:52
|
| your requirements are not fully defined, but it sounds like you may want to create a view for the 2005 data and a view for 2006. that will separate your data and likely still allow you to treat the views like base tables. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-19 : 23:30:56
|
| Or put them in separate tables in same db. |
|
|
|
|
|
|
SQL 2000 and ODBC