in terms of saving I can't think of an easy way of doing that to SQL, but it's possible via

ParititionedDataSet

and a file system