Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2195 brianf 1 
SET NOCOUNT ON;
2 
--DECLARE @date_code integer;
3 
DECLARE @start_date datetime;
4 
DECLARE @end_date datetime
5 
 
6 
--SETVAR date_code 1;
7 
 
8 
IF $(date_code) = 2
9 
BEGIN
10 
  -- test date range
11 
  SET @start_date = '20090101';
12 
  SET @end_date = '20200101';
13 
END
14 
ELSE
15 
IF $(date_code) = 3
16 
BEGIN
17 
  -- test date range for rows
18 
  SET @start_date = '20110801';
19 
  SET @end_date = '20111101';
20 
END
21 
ELSE
22 
--IF $(date_code) = 1
23 
BEGIN
24 
  -- month date range
25 
  -- set start_date to beginning of previous month
26 
  SET @start_date = DATEADD(mm,(YEAR(CURRENT_TIMESTAMP)-1900)* 12 + MONTH(CURRENT_TIMESTAMP) - 2, 0);
27 
  -- set end_date to start_date plus 1 month
28 
  SET @end_date = DATEADD(mm,1,@start_date) ;
29 
END