Error in loading master calendar

[Anonymous]

Hi,

I have used Jos Good's script to load the Master calendar but I am receiving the following error message when loading:-

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Incorrect syntax near 'MAPPING'.

I am using "InvoiceDate".

Scripts loaded.

Script attached.

Any help appreciated.

Regards,

Laura

[jagan · Accepted solution]

Hi,

You have to give ; at end of each statement

order by fa.accountnumber;

You have to replace Orders with your actual table name.

Temp: 

Load 

          min( InvoiceDate) as minDate, 

               max( InvoiceDate) as maxDate 

Resident MemberActiveProducts; 

Hope this helps you.

Regards,

Jagan.