robboll
2010-02-08 02:15:29 UTC
If I have an "Execute SQL Task" with sql that looks like this:
SELECT FLAG FROM "MyDB"."RUNorHOLD"
WHERE FY = '2010' AND PER = '4'
How can I turn '2010' and '4' into variables so it will reflect the
correct year and fiscal month regardless of when the package is run?
This may be easy but it shure has me going.
Thanks,
RBollinger
SELECT FLAG FROM "MyDB"."RUNorHOLD"
WHERE FY = '2010' AND PER = '4'
How can I turn '2010' and '4' into variables so it will reflect the
correct year and fiscal month regardless of when the package is run?
This may be easy but it shure has me going.
Thanks,
RBollinger