Posted by louisyoung187@hotmail.com on 11/02/06 11:27

The reason you are having trouble is that your data is not normalized.
Also your data is based on change over time and not on groupings, so to
accomplish this in T-SQL you'll probably have to use CURSORS which is
going to be just as complicated (if not more complicated) than doing it
in VB, so my suggestion is to normalise the database. If this is not
possible then rather stick to doing it in VB

• Next in forum: Re: Tricky group by date problem
• Prev in forum: Re: Create and then USE a dynamically-named database?
• Thread view: Re: Tricky group by date problem

[Reply to this message]