at a rough guess you might make a loop (i'm assuming you have a numerical sequential value for your row)
something like
declare @rc int=0
while @rc>0
begin
declare @lastrow int=1
select top 75000 * for JSON from mytable where id>@lastrow
set @rc=@@rowcount
set @lastrow=@lastrow+@rc
End
not sure how you are shredding the files, but this will give you multiple result sets... if that doesn't work for you then you'll have to do something similar in code. -
- find how many rows
- get first 75000
- loop using last requested value