On 2020/01/14 1:11 AM, Jose Isaias Cabrera wrote:
R Smith, on Monday, January 13, 2020 05:25 PM, wrote...
....
Wow! Thanks for this. I had not thought about your questions. My boss said,
I need to know all the changes per project whenever it happened. So,... I will
have to revise my thinking, but I have enough with your help to continue. I am
going to have to reload SQLitespeed, and try it again. :-) Thanks.
A - Es un placer,
B - It's important to really understand how they want to see changes.
Also I'm simply assuming (thanks to your example) that changes do not
happen more frequently than once a day, and that the time of it is not
important. If it is, the query will need to be adjusted.
C - I know you probably know this, but just in case it isn't 100% clear:
there is nothing about the SQL I posted that requires SQLitespeed. It is
simply the easiest for me to use and it outputs SQL+Results the way I
like it (so feel free), but that query will work in any SQLite platform
for any version of SQLite - after 3.8 that is (or 3.7... or whatever
version introduced CTE's, my memory is suddenly failing).
Good luck with your quest!
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
