Expand data in months to compare with days

[cristian_av]

Hi

I have two data sources:

a) One wich has information from a system that reads hundreds of records per day, and wich stores the data as following:

23/12/2014     Name1     OtherFields

23/12/2014     Name2     OtherFields

...

(Hundreds of records)

b) a Planning from the total of records by month:

December     4000

January     3400

February     6000

I have a master calendar wich has dates, months, and others.

But how can I compare this kind of data??

Thank you!

[Anonymous]

Hi Try this

Test:

Date              Name       OF

23/12/2014     Name1     OtherFields

23/12/2014     Name2     OtherFields

Test2:

Month         Amt

December     4000

January     3400

February     6000

load

left(MonthName(date),3) as New_Date,

Date,

Name,

OF

resident Test;

drop table Test;

left join

load

left(Month,3) as New_Date

Amt

resident Test2;

Regards

Harsha