Viewing 7 posts - 31 through 37 (of 37 total)
I don't think you should be using a database if you will be dealing with 2 entities... there is no need to overcomplicate things, excel would do the job just...
December 30, 2009 at 1:20 pm
Datawarehouse design is very complex and requires years of experience... are you sure this is what you are after, and not just a large database for relatively simple data analysis?
December 30, 2009 at 1:09 pm
Can you please post your SQL, changing relevant parts of course...
December 30, 2009 at 1:04 pm
DTS is a SQL2000 tool, it's called SSIS in 2005 if I'm correct. It imports the data into SQL. For example: migrates content of an excel file into a SQL...
December 30, 2009 at 12:51 pm
You can download addons that provide intelisense for 2000 and 2005.
December 18, 2009 at 4:37 am
The worst case scenarios described the problem rather well!! Thanks!
December 3, 2009 at 9:05 am
Thanks a lot, didn't realise that I can't have relationships between tables in different databases!
December 3, 2009 at 7:48 am
Viewing 7 posts - 31 through 37 (of 37 total)