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? Thanks.

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

can u tell me, on which basis you decide to put the data in final table.

Subodh Jha
Phoneytunes.com
India

Enjoy!
Subodh Kumar
Phoneytunes.com