I have been tasked with extracting data from an outside SQL server. The problem is that I am hitting their "live" database. They only want me to pull 15k records at a time. The connection is set up and working fine. I want to use a date, i.e. service_date to pull the records, WHERE service_date between 2018-01-01 and 2018-01-31. How do I set up the query to pull the next months data without having to go in and changing the date for each extract? All help is greatly appreciated.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.