I need to create a TempDB that that takes this table...
BRAID RATEDEFID BRADATE RATECODE PRODNAME
614 14 12/1/2002 Rack Beach Tower Terrace
615 14 12/2/2002 Rack Beach Tower Terrace
616 14 12/3/2002 Rack Beach Tower Terrace
617 14 12/4/2002 Rack Beach Tower Terrace
618 14 12/8/2002 Rack Beach Tower Terrace
619 14 12/9/2002 Rack Beach Tower Terrace
620 14 12/10/2002 Rack Beach Tower Terrace
621 14 12/11/2002 Rack Beach Tower Terrace
622 14 12/15/2002 Rack Beach Tower Terrace
623 14 12/16/2002 Rack Beach Tower Terrace
624 14 12/17/2002 Rack Beach Tower Terrace
625 14 12/18/2002 Rack Beach Tower Terrace
....and builds this table...using SQL. Any ideas?
BRAID RATEDEFID MIN(BRADATE) MAX(BRADATE RATECODE PRODNAME
614 14 12/1/2002 12/4/2004 Rack Beach Tower Terrace
618 14 12/8/2002 12/11/2004 Rack Beach Tower Terrace
622 14 12/15/2002 12/18/2004 Rack Beach Tower Terrace