sql stmt - load period data from either of two tables

[dalex]

Hello,

I seek SQL syntax that would help me achieve the following:

If current month = Aug, then get data for all previous months,(i.e Jul, Jun, May, etc...) from the ACTUALS table. Else pull data for the months from the PLAN table (i.e Aug, Sep, Oct, etc...)

Please let me know if I can clarify.

FYI - This is for a DTS process.

Thanks so much,

Dalex

 

[nomadicalloy]

use following sql function
SELECT DATEPART(month, GETDATE())
in your where clause.


SQL Help Blog

http://www.xpherion.com/blog.asp

 

[dalex]

nomadicalloy,

Could you expand on your response and provide a little more info as to how this syntax will resolve my issue? What does this syntax do?

Thank you,

Dalex