Re: [sqlite] Reverse Referencing Rows

ite-users-boun...@sqlite.org] On Behalf Of Simon Slavin #>Sent: Wednesday, November 11, 2009 4:53 PM #>To: General Discussion of SQLite Database #>Subject: Re: [sqlite] Reverse Referencing Rows #> #> #>On 11 Nov 2009, at 7:12pm, Rick Ratchford wrote: #> #>> To determine

Re: [sqlite] Reverse Referencing Rows

On 11 Nov 2009, at 7:12pm, Rick Ratchford wrote: > To determine if the set is complete, there would clearly be data rows PRIOR > to the start date and data rows that FOLLOW the end date. This is how I'd > determine that a set is complete with all available data for those 'sample > date windows'.

Re: [sqlite] Reverse Referencing Rows

Thanks. Rick #>-Original Message- #>From: sqlite-users-boun...@sqlite.org #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik #>Sent: Wednesday, November 11, 2009 12:38 PM #>To: sqlite-users@sqlite.org #>Subject: Re: [sqlite] Reverse Referencin

Re: [sqlite] Reverse Referencing Rows

Rick Ratchford wrote: > Only business days are in the data sets. No weekends or Holidays. > > So I was happy with the other sets because they ARE full sets. > > A full set is ALL THE BUSINESS DAYS from the Start to End Date. Do you have a table that lists all the

Re: [sqlite] Reverse Referencing Rows

te.org #>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik #>Sent: Wednesday, November 11, 2009 11:44 AM #>To: sqlite-users@sqlite.org #>Subject: Re: [sqlite] Reverse Referencing Rows #> #>Rick Ratchford <r...@amazingaccuracy.com> #>wrote: #>> #>

Re: [sqlite] Reverse Referencing Rows

Rick Ratchford wrote: > #>> > #>> Date | Year | Month | Day > #>> > #>> 12/28/1988 1988 12 28 > #>> 12/29/1988 1988 12 29 > #>> 12/30/1988 1988 12 30 > #>> 01/04/1988 1988 01 04 > #>> 01/05/1988 1988 01 05 > #>> 12/28/1989 1989 12

Re: [sqlite] Reverse Referencing Rows

#>> #>> Date | Year | Month | Day #>> #>> 12/28/1988 1988 12 28 #>> 12/29/1988 1988 12 29 #>> 12/30/1988 1988 12 30 #>> 01/04/1988 1988 01 04 #>> 01/05/1988 1988 01 05 #>> 12/28/1989 1989 12 28 #>> 12/29/1989 1989 12 29 #>> 01/03/1989 1989 01

Re: [sqlite] Reverse Referencing Rows

"Rick Ratchford" schrieb im Newsbeitrag news:dbfb2606d0c1448b930064474496a...@dolphin... > A while back, Igor gave me some help on pulling out mm/dd ranges (sets) from > my table. > > This is the code that does that. > > sSQL = "SELECT Date, Year, Month, Day, Open,

Re: [sqlite] Reverse Referencing Rows

Rick Ratchford wrote: > For example, say that I want to run this SQL statement to pull out SETS that > start with a MM/DD of 12/28 to 01/05. That means, each 'set' would be from > December 25 to January 05, which means that each 'set' will cross a year end > date (where the year value increments

Re: [sqlite] Reverse Referencing Rows

To add to my last post shown below, what I've done is added the "Date" to the ORDER BY, thus putting the unwanted rows at the very top. It doesn't remove it, but it does allow for stripping it off easier when transferring to an array if that is the best way to go. sSQL = "SELECT Date, Year,