Best approach for large amount of data

2001-02-28 Thread Robert Badaracco
Hi, I've got 350 mailing lists that have approx 32 fields. Each list will have between 100k to 200k records. Should I create a database for each individual list or create one database with one table for each? If I take the latter approach I'll end up with 35 - 70 million records in a single

How to query and return nearest value...

2001-01-23 Thread Robert Badaracco
Hi, I have a range of decimal numbers (Prices) in a table column that I'd like to run a query against. I'd like to run a query with a value that returns the closest price to that value if it can't find a match. Is there some function that I can use in my query that will allow me to do this?