Archives of the TeradataForum
Message Posted: Fri, 26 Apr 2002 @ 14:27:10 GMT
| Subj: || || Re: Converting 4-digit dates to standard date |
| From: || || John Balchunas |
Successfully populated a new table converting 5 full dates thru an Insert/Select and CASE on each date. 52 million rows took just about
three hours during the workday on an old 4-node 4700 without any apparent degradation of performance.
Thanks all for your help and to Mike Larkins for his class on optimizing CASE at Midwest TUG on April 23rd in Dayton.
Jefferson County Public Schools