Load data day by day using loop

[qlikwiz123]

I have to query data from SQL based system. Due to the limitations and the available bandwidth, I cannot load the entire dataset in one SQL go.

How do I write my SQL query to pull 1 day worth of data and then loop through it until I have all the data till the maximum date?

I have a date field -RecordDate in the data table that I can use to identify the record date.

[qlikwiz123]

@mfchmielowski 

Wonderful. Thank you