Good idea, there must be a SQL function for that maybe? I know how to do all that in CF, but not how to encapsulate in a SQL query! Unfortunately since it is a reporting function, its way too cumbersome to do in CF and would like to run in a SQL one time shot. (***searching for a decent SQL book***?)
Regards, Eric -----Original Message----- From: Parker, Kevin [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 6:42 PM To: CF-Talk Can you check if the day number is between 2 and 6 inc. ********** Kevin Parker Web Services Manager WorkCover Corporation e: [EMAIL PROTECTED] w: www.workcover.com p:+ 61 8 8233 2548 f: +61 8 8233 2282 m: 0418 806 166 ********** -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 22 August 2003 9:00 AM To: CF-Talk Subject: Business Day in SQL Query Does anyone have an example, or is this even possible without straining a brain muscle, how to pull data from a MS SQL 2000 database only if that data is date stamped on a weekday?? Has to be done in the SQL query... Thanks for any pointers!! Regards, Eric J. Hoffman DataStream Connexion www.datastreamconnexion.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
