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. Cheers! 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 11:44 AM #>To: sqlite-users@sqlite.org #>Subject: Re: [sqlite] Reverse Referencing Rows #> #>Rick Ratchford <r...@amazingaccuracy.com> #>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 28 #>> #>> 12/29/1989 1989 12 29 #>> #>> 01/03/1989 1989 01 03 #>> #>> 01/04/1989 1989 01 04 #>> #>> 01/05/1989 1989 01 05 #>> #>> #>> #>> As you can see, the first set has a problem It goes from #>> #>December 28, #>> 1988 to January 05, 1988, rather than #>January 05, #>> 1989 #>like it should #>> for the first SET. #>> #> #>> #>Actually, it only seems this way due to the sorting #>order. If #>you #>> just do "ORDER BY Year, Month, Day" you'll see what's #>#>going on. You #>> have one set going from 12/28/87 to 01/05/88 #>(which just #>happens to #>> be incomplete as you have no records #>in 1987), and #>another unrelated #>> set going from 12/28/88 to #>01/05/89. Your overcomplicated #>ORDER BY #>> clause causes these #>two sets to interleave. #>> #>> This would then bring up another issue. Only COMPLETE SETS #>are needed, #>> not partial ones. #> #>Define "complete set". You seem to be happy with 1988-1989 #>one, even though it's missing 3 days out of 9. Sounds pretty #>partial to me. #> #>> #>> I fugure the way to correct this issue is to make sure #>that each #>> ROW #>> (record) has a DATE that is greater than the last ROW. #>> #> #>> #>So, just say that in ORDER BY. #>> #>> Is that what I did when I added "Date" to my ORDER BY? #> #>Which part of "ORDER BY Year, Month, Day" do you find unclear? #> #>Igor Tandetnik #> #>_______________________________________________ #>sqlite-users mailing list #>sqlite-users@sqlite.org #>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users #> #> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users