I have a DTS which runs multiple queries pulling the same type of data from
similar tables. One of the 'where' conditions is a date range but this date
is going to change from month to month. To prevent me having to alter the
where clause of each individual query to pull the current date range, is
there a way to specify the date range for the whole DTS, so I can enter the
date range once and each query would run off of that range?

Any advice would be appreciated.

Alan

How about you define the Range as parameters so

SELECT................
WHERE StartDate >= ? And EndDate <= ?

You can then map the ? to Global variables

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"awwtau" <awwtau (AT) discussions (DOT) microsoft.com> wrote