Re: Article by Joe Celko - Mimicking magnetic tape in SQL - A

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I haven't actually ported and ran the original code, but I believe
that your results match the original...

Exception being the original code used a column name of
sales_delta_tot....and the new one uses sales_amt_tot; but
sales_delta_tot is probably more appropriate IMO.

Also, judging from the comments at the bottom of the page, the
original article publish an older version of the code; the article was
updated today around 8:30 ET.

Charles


On Mon, Aug 29, 2011 at 12:41 PM, James Horn <jdhorn@xxxxxxxxxxxxxx> wrote:
> I tried it.  Unfortunately couldn't understand the need for all the
> "original" code.  Can someone who is better at SQL than me look at the
> original code and the replacement code and say they are doing the same
> thing?  When I ran the replacement code in strsql this was the result.
>
> REPORT_PERIOD   STORE_ID                 SALES_AMT_TOT
>  2011-00-00                1
> 43.50
>  2011-00-00                2
> 44.25
>
> Is this what the original would have done?
> --
> Jim Horn
> CATCO  651-697-6314    JDHorn@xxxxxxxxxxxxxx
> Cell   612-791-3924
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.