Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

where date1 > ? AND date2 <= GETDATE() does not work in yukon Expand / Collapse
Author
Message
Posted Friday, March 9, 2007 4:06 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 8:30 AM
Points: 907, Visits: 1,898
hi. the where condition in a dts package is as follows:

where date1 > ? AND date2 <= GETDATE()

 

The qustion sign wont work in sql server 2005 query window. what is the modern day equivalent of this?

Post #350296
Posted Friday, March 9, 2007 7:13 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:34 PM
Points: 3,109, Visits: 11,516

Just put in the date and time you want to start with:

where date1 > '20070308 02:45:00.000' AND date2 <= GETDATE() 
Post #350349
Posted Friday, March 9, 2007 7:31 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 8:30 AM
Points: 907, Visits: 1,898
i dont know what date or time should be there though! there is a ? sign, and i dont know what date time that represents in sql server 2000
Post #350355
Posted Friday, March 9, 2007 8:43 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Saturday, March 8, 2014 4:25 PM
Points: 1,415, Visits: 1,228

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 ?

Post #350390
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse