Hi,
I have the following shell script:
:XML ON
DECLARE @Begin CHAR(10), @End CHAR(10)
SET @Begin = '1'
SET @End = '1000'
exec dbo.example_storedproc @Begin, @End;
I want to break up by batches of 100 intervals. So for example, the first @Begin will be 1 and@End will be 100. The second batch will be @Begin =101 and @End =201. Is there any way to run the results into a file in a directory with date/time(24 hr zone)/@End # for each interval processed on Windows?
Thank you,
Yen