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

aaron.kempf@xxxxxxxxx wrote...
>and databases have a LOT more than select, for starters there is
>UPDATE, DELETE, INSERT..

*NOT* for referencing existing data they don't. These queries all
CHANGE tables, only SELECT fetches data from tables.

>the WITH clause (of MDX and CTEs)

Irrelevant - again you're assuming the existence of additional
software. If I assumed a full SAS system interfaced with a SQL
database, could I then claim all SAS data step code was just part of
the database interface? Well, if I were you I guess I could, but
thinking people would have a different opinion.

.

Loading