I am trying to do an insert from 1 table to another in increments based on a ceiling of a date field converted to an integer using a T-SQL WHILE...BREAK...CONTINUE Loop.
I've got the code working fine to do the insert but am having difficulty breaking out of the loop once the ceiling condition is reached. It is bringing in all the records instead. Attached is a sample code file. Any assistance is MUCH appreciated. -- Thanks!