How to run a minus query iteratively for a date range.

General
K_Y
Enthusiast

How to run a minus query iteratively for a date range.

Hi

 

I have to compare two two tables for some 30 days, when i run a minus query between two for each date , the data matches but when i run the MINUS query for 30 days at a single shot using between clause , the data does not match.

 

So i have to repeat same MINUS query for 30 days repeadtly changing date at each run , how to achive that .

 

Could anyone please help on this.

 

Thanks

Kavita