In XSLT 1.0, each transformation can only produce one result document. So
you will have to organize some kind of script that invokes the same
transformation repeatedly, supplying parameters to indicate which range of
rows you want to select on each run.

Mike,
I remember, in those good old days, you had a saxon extention
equivalent to the current day's  xsl:result-document ...
something like :
  <saxon:output href="{$file}">
   </saxon:output>

Michael Kay
Saxonica