Welcome Guest, you are in: <root> • Anmelden

Eintragshistorie: A Faster BETWEEN Dates

Compare Page Revisions

4 3 2 1 0 Aktuell 4 3 2 1 0

« Ältere Version - Zurück zu der Eintragshistorie - Neuere Version »

Eintragsversion: 13/04/2011 14:20

/*

Test Project table definition and data load.

• /
  DECLARE @ProjectList table
  (
  Proj_ID int,
  Proj_Name varchar(60),
  Proj_Start datetime,
  Proj_End datetime
  )
  INSERT INTO @ProjectList
  SELECT
  1 AS Proj_ID,
  'Discuss Building' AS Proj_Name,
  '1997-01-15' AS Proj_Start,
  '1997-07-20' AS Proj_End
  UNION
  SELECT
  2 AS Proj_ID,
  'Draw Building Plan' AS Proj_Name,
  '1997-07-21' AS Proj_Start,
  '1998-09-15' AS Proj_End
  UNION
  SELECT
  3 AS Proj_ID,
  'Argue About Fees' AS Proj_Name,
  '1998-03-01' AS Proj_Start,
  '1999-10-20' AS Proj_End
  UNION
  SELECT
  4 AS Proj_ID,
  'Groundbreaking' AS Proj_Name,
  '1998-11-01' AS Proj_Start,
  '1998-11-02' AS Proj_End
  UNION
  SELECT
  5 AS Proj_ID,
  'Construction' AS Proj_Name,
  '1998-11-01' AS Proj_Start,
  '2001-05-06' AS Proj_End
  UNION
  SELECT
  6 AS Proj_ID,
  'Stock The Supplies' AS Proj_Name,
  '2001-01-04' AS Proj_Start,
  '2001-07-20' AS Proj_End
  UNION
  SELECT
  7 AS Proj_ID,
  'Order The Books' AS Proj_Name,
  '2001-06-01' AS Proj_Start,
  '2003-06-30' AS Proj_End
  UNION
  SELECT
  8 AS Proj_ID,
  'Publisher Problems' AS Proj_Name,
  '2001-07-01' AS Proj_Start,
  '2004-08-18' AS Proj_End
  UNION
  SELECT
  9 AS Proj_ID,
  'Stock The Shelves' AS Proj_Name,
  '2002-02-01' AS Proj_Start,
  '2005-03-27' AS Proj_End
  UNION
  SELECT
  10 AS Proj_ID,
  'Library Is Open' AS Proj_Name,
  '2004-11-01' AS Proj_Start,
  '2012-12-11' AS Proj_End
  /*
  

Test Work table definition and data load.

• /
DECLARE @WorkTable table
(
Work_ID int,
Work_Start datetime,
Work_End datetime
)
INSERT INTO @WorkTable
SELECT 1, '1997-01-15', '1998-01-14'
UNION SELECT 2, '1997-02-01', '1997-03-01'
UNION SELECT 3, '1997-03-01', '1997-04-01'
UNION SELECT 4, '1997-04-01', '1997-05-01'
UNION SELECT 5, '1997-05-01', '1997-06-01'
UNION SELECT 6, '1997-06-01', '1997-07-01'
UNION SELECT 7, '1997-07-01', '1997-08-01'
UNION SELECT 8, '1997-08-01', '1997-09-01'
UNION SELECT 9, '1997-09-01', '1997-10-01'
UNION SELECT 10, '1997-10-01', '1997-11-01'
UNION SELECT 11, '1997-11-01', '1997-12-01'
UNION SELECT 12, '1997-12-01', '1998-01-01'
UNION SELECT 13, '1998-01-01', '1998-02-01'
UNION SELECT 14, '1998-02-01', '1998-03-01'
UNION SELECT 15, '1998-03-01', '1998-04-01'
UNION SELECT 16, '1998-04-01', '1998-05-01'
UNION SELECT 17, '1998-05-01', '1998-06-01'
UNION SELECT 18, '1998-06-01', '1998-07-01'
UNION SELECT 19, '1998-07-01', '1998-08-01'
UNION SELECT 20, '1998-08-01', '1998-09-01'
UNION SELECT 21, '1998-09-01', '1998-10-01'
UNION SELECT 22, '1998-10-01', '1998-11-01'
UNION SELECT 23, '1998-11-01', '1998-12-01'
UNION SELECT 24, '1998-12-01', '1999-01-01'
UNION SELECT 25, '1999-01-01', '1999-02-01'
UNION SELECT 26, '1999-02-01', '1999-03-01'
UNION SELECT 27, '1999-03-01', '1999-04-01'
UNION SELECT 28, '1999-04-01', '1999-05-01'
UNION SELECT 29, '1999-05-01', '1999-06-01'
UNION SELECT 30, '1999-06-01', '1999-07-01'
UNION SELECT 31, '1999-07-01', '1999-08-01'
UNION SELECT 32, '1999-08-01', '1999-09-01'
UNION SELECT 33, '1999-09-01', '1999-10-01'
UNION SELECT 34, '1999-10-01', '1999-11-01'
UNION SELECT 35, '1999-11-01', '1999-12-01'
UNION SELECT 36, '1999-12-01', '2000-01-01'
UNION SELECT 37, '2000-01-01', '2000-02-01'
UNION SELECT 38, '2000-02-01', '2000-03-01'
UNION SELECT 39, '2000-03-01', '2000-04-01'
UNION SELECT 40, '2000-04-01', '2000-05-01'
UNION SELECT 41, '2000-05-01', '2000-06-01'
UNION SELECT 42, '2000-06-01', '2000-07-01'
UNION SELECT 43, '2000-07-01', '2000-08-01'
UNION SELECT 44, '2000-08-01', '2000-09-01'
UNION SELECT 45, '2000-09-01', '2000-10-01'
UNION SELECT 46, '2000-10-01', '2000-11-01'
UNION SELECT 47, '2000-11-01', '2000-12-01'
UNION SELECT 48, '2000-12-01', '2001-01-01'
UNION SELECT 49, '2001-01-01', '2001-02-01'
UNION SELECT 50, '2001-02-01', '2001-03-01'
UNION SELECT 51, '2001-03-01', '2001-04-01'
UNION SELECT 52, '2001-04-01', '2001-05-01'
UNION SELECT 53, '2001-05-01', '2001-06-01'