finding max value between dates

Question

finding max value between dates

astrid 69000

Hall of Fame

Points: 3208
More actions
September 18, 2016 at 4:22 am

#313679

hi,
i need to find the max values between two dates, the present one and a year from now.
and my mind went blank :w00t::w00t::w00t::w00t:
so i have a table
create table temp
(
dates datetime
,customer int
,ind_1 smallint
,ind_2 smallint
,ind_3 smallint
,ind_4 smallint
)
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2013-10-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2013-11-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2013-12-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-01-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-02-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-03-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-04-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-05-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-06-01', 1243, 0, 0, 0, 1);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-07-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-08-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-09-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-10-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-11-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-12-01', 1243, 0, 0, 1, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2015-01-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2015-02-01', 1243, 1, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2015-03-01', 1243, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2013-10-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2013-11-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2013-12-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-01-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-02-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-03-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-04-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-05-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-06-01', 2323, 0, 0, 0, 1);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-07-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-08-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-09-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-10-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-11-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2014-12-01', 2323, 0, 0, 1, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2015-01-01', 2323, 0, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2015-02-01', 2323, 1, 0, 0, 0);
insert into temp (dates, customer, ind_1, ind_2, ind_3, ind_4) values ('2015-03-01', 2323, 0, 0, 0, 0);
and i need to get 4 new columns saying whether the ind column turn active(1) within the next year.
help please :-P:-P
thanks!!

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 1

Quick question, why is the latest date in the sample set 2015-03-01? This means that the data is all excluded by the requirements.

😎

astrid 69000 Hall of Fame Points: 3208 More actions · Answer 2

no no, it is not a year from today, it is within the year of that date, the table is huge so i just wrote the sample

so if the date is 2013-10-01 i need to check where the indicator on that specific column changed to 1 between dates 2013-10-01 and 2014-10-01

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 3

thanks for sample data......could you please provide expected results for this sample (think I know what you are looking for...but this will clarify)

also....in your sample data you have only one row per customer/month (and always the first of the month and never any missing months)...is this always the case?

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 4

Here is a quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_DATA_1818603') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DATA_1818603;

create table dbo.TBL_SAMPLE_DATA_1818603

(

dates datetime

,customer int

,ind_1 smallint

,ind_2 smallint

,ind_3 smallint

,ind_4 smallint

)

insert into dbo.TBL_SAMPLE_DATA_1818603

(dates, customer, ind_1, ind_2, ind_3, ind_4)

values ('2013-10-01', 1243, 0, 0, 0, 0)

,('2013-11-01', 1243, 0, 0, 0, 0)

,('2013-12-01', 1243, 0, 0, 0, 0)

,('2014-01-01', 1243, 0, 0, 0, 0)

,('2014-02-01', 1243, 0, 0, 0, 0)

,('2014-03-01', 1243, 0, 0, 0, 0)

,('2014-04-01', 1243, 0, 0, 0, 0)

,('2014-05-01', 1243, 0, 0, 0, 0)

,('2014-06-01', 1243, 0, 0, 0, 1)

,('2014-07-01', 1243, 0, 0, 0, 0)

,('2014-08-01', 1243, 0, 0, 0, 0)

,('2014-09-01', 1243, 0, 0, 0, 0)

,('2014-10-01', 1243, 0, 0, 0, 0)

,('2014-11-01', 1243, 0, 0, 0, 0)

,('2014-12-01', 1243, 0, 0, 1, 0)

,('2015-01-01', 1243, 0, 0, 0, 0)

,('2015-02-01', 1243, 1, 0, 0, 0)

,('2015-03-01', 1243, 0, 0, 0, 0)

,('2013-10-01', 2323, 0, 0, 0, 0)

,('2013-11-01', 2323, 0, 0, 0, 0)

,('2013-12-01', 2323, 0, 0, 0, 0)

,('2014-01-01', 2323, 0, 0, 0, 0)

,('2014-02-01', 2323, 0, 0, 0, 0)

,('2014-03-01', 2323, 0, 0, 0, 0)

,('2014-04-01', 2323, 0, 0, 0, 0)

,('2014-05-01', 2323, 0, 0, 0, 0)

,('2014-06-01', 2323, 0, 0, 0, 1)

,('2014-07-01', 2323, 0, 0, 0, 0)

,('2014-08-01', 2323, 0, 0, 0, 0)

,('2014-09-01', 2323, 0, 0, 0, 0)

,('2014-10-01', 2323, 0, 0, 0, 0)

,('2014-11-01', 2323, 0, 0, 0, 0)

,('2014-12-01', 2323, 0, 0, 1, 0)

,('2015-01-01', 2323, 0, 0, 0, 0)

,('2015-02-01', 2323, 1, 0, 0, 0)

,('2015-03-01', 2323, 0, 0, 0, 0);

DECLARE @DATE_TO_USE DATETIME = '2013-10-01';

;WITH BASE_DATA AS

(

SELECT

SD.customer

,SD.dates

,SD.ind_1

,SD.ind_2

,SD.ind_3

,SD.ind_4

,CASE

WHEN SD.ind_1 > 0 THEN 1

WHEN SD.ind_2 > 0 THEN 2

WHEN SD.ind_3 > 0 THEN 3

WHEN SD.ind_4 > 0 THEN 4

END AS FLAG

FROM dbo.TBL_SAMPLE_DATA_1818603 SD

WHERE SD.dates > CONVERT(DATETIME,CONVERT(DATE,DATEADD(DAY,-1,@DATE_TO_USE),0),0)

AND (

ind_1 > 0

OR ind_2 > 0

OR ind_3 > 0

OR ind_4 > 0

)

SELECT

BD.customer

,MAX(BD.dates) AS LAST_CHANGED_DATE

,BD.FLAG

FROM BASE_DATA BD

GROUP BY BD.customer,BD.FLAG;

Output

customer LAST_CHANGED_DATE FLAG

----------- ----------------------- -----------

1243 2015-02-01 00:00:00.000 1

2323 2015-02-01 00:00:00.000 1

1243 2014-12-01 00:00:00.000 3

2323 2014-12-01 00:00:00.000 3

1243 2014-06-01 00:00:00.000 4

2323 2014-06-01 00:00:00.000 4

astrid 69000 Hall of Fame Points: 3208 More actions · Answer 5

astrid 69000

Hall of Fame

Points: 3208

September 18, 2016 at 6:28 am

#1901528

thanks but this is not what i am looking for

astrid 69000 Hall of Fame Points: 3208 More actions · Answer 6

this is the result i need

i have attached an excel cause i dont know how to make a sample of a table to show it.

astrid 69000 Hall of Fame Points: 3208 More actions · Answer 7

i wrote this, what do you think?

Select

t.dates, t.customer, t.ind_1, t.ind_2, t.ind_3, t.ind_4,

ind_1_yearafter=(

Select max(ind_1)

From temp ex

Where ex.dates between t.dates and dateadd(year,1,t.dates)

)

From temp t

order by t.dates

Jeff Moden SSC Guru Points: 1004343 More actions · Answer 8

astrid 69000 (9/18/2016)
i wrote this, what do you think?
Select
t.dates, t.customer, t.ind_1, t.ind_2, t.ind_3, t.ind_4,
ind_1_yearafter=(
Select max(ind_1)
From temp ex
Where ex.dates between t.dates and dateadd(year,1,t.dates)
)
From temp t
order by t.dates

Depends... does it do what you want to?

Once we know that, then we might be able to suggest a method to make the sub-query SARGable for reasons of performance.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 9

astrid 69000 (9/18/2016)
this is the result i need
i have attached an excel cause i dont know how to make a sample of a table to show it.

That's similar to what you said in your very first post three and a half years ago -

http://www.sqlservercentral.com/Forums/Topic1429759-17-1.aspx

Here's a link to show you how to create a table:

https://msdn.microsoft.com/en-GB/library/ms174979.aspx

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 10

astrid 69000 (9/18/2016)
this is the result i need
i have attached an excel cause i dont know how to make a sample of a table to show it.

Really?? You were able to create a table and provide sample data in your initial post on this thread. You do the same thing except with your expected results.

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 11

Lynn Pettis (9/19/2016)
astrid 69000 (9/18/2016)
this is the result i need
i have attached an excel cause i dont know how to make a sample of a table to show it.
Really?? You were able to create a table and provide sample data in you initial post on this thread. You do the same thing except with your expected results.

heres a quick tip if you have a "table like" structure in excel and wish to create a script

go here : http://www.convertcsv.com/csv-to-sql.htm

cut and paste your excel into the formatter > amend datatypes accordingly > generate output (csv to SQL insert) > copy and paste into SSMS/SSC wherever

volia :

CREATE TABLE tablenamehere(

date DATE NOT NULL

,customerid INT NOT NULL

,ind_1 INT NOT NULL

,ind_2 INT NOT NULL

,ind_3 INT NOT NULL

,ind_4 INT NOT NULL

,ind_1_year_after INT NOT NULL

,ind_2_year_after INT NOT NULL

,ind_3_year_after INT NOT NULL

,ind_4_year_after INT NOT NULL

);

INSERT INTO tablenamehere(date,customerid,ind_1,ind_2,ind_3,ind_4,ind_1_year_after,ind_2_year_after,ind_3_year_after,ind_4_year_after) VALUES

('2013/10/01',1243,0,0,0,0,0,0,0,1)

,('2013/11/01',1243,0,0,0,0,0,0,0,1)

,('2013/12/01',1243,0,0,0,0,0,0,0,1)

,('2014/01/01',1243,0,0,0,0,0,0,1,1)

,('2014/02/01',1243,0,0,0,0,0,0,1,1)

,('2014/03/01',1243,0,0,0,0,1,0,1,1)

,('2014/04/01',1243,0,0,0,0,1,0,1,1)

,('2014/05/01',1243,0,0,0,0,1,0,1,1)

,('2014/06/01',1243,0,0,0,1,1,0,1,1)

,('2014/07/01',1243,0,0,0,0,1,0,1,0)

,('2014/08/01',1243,0,0,0,0,1,0,1,0)

,('2014/09/01',1243,0,0,0,0,1,0,1,0)

,('2014/10/01',1243,0,0,0,0,1,0,1,0)

,('2014/11/01',1243,0,0,0,0,1,0,1,0)

,('2014/12/01',1243,0,0,1,0,1,0,1,0)

,('2015/01/01',1243,0,0,0,0,1,0,0,1)

,('2015/02/01',1243,1,0,0,0,1,0,0,1)

,('2015/03/01',1243,0,0,0,0,0,0,0,1)

,('2013/10/01',2323,0,0,0,0,0,0,0,1)

,('2013/11/01',2323,0,0,0,0,0,0,0,1)

,('2013/12/01',2323,0,0,0,0,0,0,0,1)

,('2014/01/01',2323,0,0,0,0,0,0,1,1)

,('2014/02/01',2323,0,0,0,0,0,0,1,1)

,('2014/03/01',2323,0,0,0,0,1,0,1,1)

,('2014/04/01',2323,0,0,0,0,1,0,1,1)

,('2014/05/01',2323,0,0,0,0,1,0,1,1)

,('2014/06/01',2323,0,0,0,1,1,0,1,1)

,('2014/07/01',2323,0,0,0,0,1,0,1,0)

,('2014/08/01',2323,0,0,0,0,1,0,1,0)

,('2014/09/01',2323,0,0,0,0,1,0,1,0)

,('2014/10/01',2323,0,0,0,0,1,0,1,0)

,('2014/11/01',2323,0,0,0,0,1,0,1,0)

,('2014/12/01',2323,0,0,1,0,1,0,1,0)

,('2015/01/01',2323,0,0,0,0,1,0,0,0)

,('2015/02/01',2323,1,0,0,0,1,0,0,0)

,('2015/03/01',2323,0,0,0,0,0,0,0,0);

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

astrid 69000 Hall of Fame Points: 3208 More actions · Answer 12

i meant i didnt know how to create a table as a table here :-D:-D

not a table in sql...

anyhow i double checked and it was not exactly what i need.

i just need is one column on a specific customer is 0 to be able to calculate if in the next year any month it changed from 0 to 1.

astrid 69000 Hall of Fame Points: 3208 More actions · Answer 13

and yes, i check my previous post and still dont know how to post a table as a table here and not as code :doze:

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 14

astrid 69000 (9/22/2016)
and yes, i check my previous post and still dont know how to post a table as a table here and not as code :doze:

do you mean like this?

try http://www.tablesgenerator.com/text_tables

and paste with plain code tags

+-------------------------------------------------------------------------------------------------------------------------------------+

¦ date ¦ customerid ¦ ind_1 ¦ ind_2 ¦ ind_3 ¦ ind_4 ¦ ind_1_year_after ¦ ind_2_year_after ¦ ind_3_year_after ¦ ind_4_year_after ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2013/10/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2013/11/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2013/12/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/01/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/02/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/03/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/04/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/05/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/06/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 1 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/07/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/08/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/09/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/10/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/11/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/12/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2015/01/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 0 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2015/02/01 ¦ 1243 ¦ 1 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 0 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2015/03/01 ¦ 1243 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2013/10/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2013/11/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2013/12/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/01/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/02/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/03/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/04/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/05/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/06/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 1 ¦ 0 ¦ 1 ¦ 1 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/07/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/08/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/09/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/10/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/11/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2014/12/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦ 1 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2015/01/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 0 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2015/02/01 ¦ 2323 ¦ 1 ¦ 0 ¦ 0 ¦ 0 ¦ 1 ¦ 0 ¦ 0 ¦ 0 ¦

¦------------+------------+-------+-------+-------+-------+------------------+------------------+------------------+------------------¦

¦ 2015/03/01 ¦ 2323 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦ 0 ¦

+-------------------------------------------------------------------------------------------------------------------------------------+

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day