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

Query Into <Tmp Table Name>

Or. Use Create Command in PLSQL

Gokulan Ethiraj

Is that related to SQL server or ORACLE? What db are you using?

_________________________
- Vijay G
Strive for Perfection

use Select... Into... From using SQL Server

Regards
Ganesh

opuspocus,

Were you able to figure out how to do that? Has this been resolved?

Cheers!

_________________________
- Vijay G
Strive for Perfection