Recent content by lennym

Thanks very much...you guys are fast. This is the one I was looking for... - LennyM

Some time ago, someone gave me a script to run to create a table called "time_dimension" which I used to calculate elapsed working days, excluding holidays and weekends. The table produced a value of 1 for regular days and 0 for holidays and weekends, by simply using the sum count...

I need to perform a select statement where I select a 4% random sample of the results of a query. EG: I select a group of records from a table based on a date range and then I want to select a random 4% sample of the results. Does anyone have any suggestions for this? Thanks muchly.

I currently transfer data from one SQL7 database to another using DTS and I would like to set up an automated procedure to add columns which will contain data that calculates the working days between two date fields in the original table.  I am using a time_dimension table and formula...

I have created a table called time_dimension which lists all dates from 1996 to 2001.  The table contains a column called the_date with the continuous date values from 1996 to 2001 and a column called countable_day which has a value of 1 for dates that are work days and 0 for dates...

I am using an SQL version7 database that contains tables with date columns. I would like to add a column to a table that calculates in days, the difference between two other columns, taking into account that I only want to count days where its Monday to Friday. Also, I would like to take into...