where date1 > ? AND date2 <= GETDATE()
The qustion sign wont work in sql server 2005 query window. what is the modern day equivalent of this?
Just put in the date and time you want to start with:
where date1 > '20070308 02:45:00.000' AND date2 <= GETDATE()
The '?' is a parameter placeholder. In Sql2K DTS, it would typically be replaced at runtime by a DTSGlobalVariable, presumably so that the DTS package could be dynamically run for different date/time periods.
Is this still a DTS package running under SQL2K5, or has the package migrated to SSIS ?
