Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.