Re: The best elegant solution to override 65k rows limit in a ***

aaron.kempf@xxxxxxxxx wrote...
>select is about 100 times more powerful than spreadsheets.

If you want to select data pretty much as it comes from one table or
several joined tables, perhaps. If you want to correspond values from
some field but from different records, it gets difficult very quickly.

Consider another simple example: 5 point moving averages from a table
in which the first field is observation number and the second field is
observation value. In Excel, real difficult: sort the table on
observation number in ascending order, then starting with the 5th
observation, average the first 5 values up to the current record's (5th
observation's) value, then fill that formula down for the remaining
records.

What sort of gyrations does something this simple require in a SELECT
query? Pure SQL, no assuming additional software like Analysis
Services.

>i mean.. storing data in one place and then pointing to it-- it is a
>lot easier than pulling around all your data and emailling all your
>data to your clients

Unless one's IT department won't provide access to anyone outside the
company, in which case, oh great genius, how does one share data with
customers/clients? Hint: not by an ODBC or web database feed.

>databases make the world go around

Excretion is a necessary part of living . . . and an unavoidable aspect
of your postings.

.