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

and databases have a LOT more than select, for starters there is
UPDATE, DELETE, INSERT..

the WITH clause (of MDX and CTEs)

I can figure out enough about Excel to say that I'm tired of keeping my
important numbers in 300 different places.

I keep my calculations in a database; and then i can spit them out into
Excel, Crystal, ASP.. i can display numbers in 100 different formats.
10,000 different formats for christ sakes.

And you idiots are still emailign around 100mb XLS files.. I mean..
WAKE UP AND SMELL THE COFFEE; EXCEL WAS PASSE IN 1995.

.

Loading