View Single Post
Old 03-20-2009, 09:53 AM   #3 (permalink)
kmote
 

Join Date: Jul 2005

Location: England

Posts: 2,177

kmote has a spectacular aura aboutkmote has a spectacular aura about

Default Re: collating records from different SQL Server tables

I'll need to see the structure of the tables including the indexes. If this is an example database, it may be trying to demonstrate the use of linking tables even though this would not be done in production.
__________________
MSI P43 Neo|Enermax Pro82+ 425W|E5200|silent 8500GT|250GB Samsung spinpoint F1|Samsung SATA DVD RW|4GB Corsair|Antec SOLO|openSUSE11


There are in order of increasing severity: lies, darn lies, statistics, and computer benchmarks. - diskinfo man page
kmote is online now