I need to call SQLite script passing a date period for parameter.
I have an existing SQL script but not developed for SQLite.
I want you to adapt the script to make it parameterisable + have a day granularity.
The data is a lit of invoicess with columns
ID = customer id
VID = invoice id
AM = invoice amount
VD = invoice date
TD = invoice term date
PD = invoice paiment date
All date are integer format yyyymmdd
The script to adapt uses
od = PD-TD
pd = PD-VD
amount_curr = AM
The good news is because we change the granularity to day you can use 360 day to create the new table.
Attached the SQLite db that contains data + parameter (period start for 360 days)
The sql script to adpat.
If you can make it run for all SQL engine it's a plus !
SQLiteStudio is your friend.
I need the script for saturday morning UTC
December 23, 2017
I am looking for a mix of experience and value