Unless you are willing to provide details we can't help. Keep in mind that I can't see your screen, I have no idea what your tables are like, I have no idea what you are trying to accomplish. I only know what you have posted, which is next to nothing. In your second post you have added details about "catering for the previous 18 months". I have no idea what that means. Do you need to adjust your where clause to have some date checks? You say you need to adjust your where clause slightly. Does that mean you need to use a different value for the same column or do the columns being filtered changed? I am not saying you need to post your entire enterprise structure here but you must post enough details so that we know what the question is. At this point, all I know is that you want some help trying to figure out how to automate running some queries that need to change a little bit for each select statement.