Friday, March 23, 2012

NEED SQL HELP PLEASE

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 TerraceSELECT BRAID,
RATEDEFID,
MIN(BRADATE),
MAX(BRADATE),
RATECODE,
PRODNAME
FROM YourTable
GROUP BY BRAID,
RATEDEFID,
RATECODE,
PRODNAME

?

"Michael" <michael.hardy@.kerzner.com> wrote in message
news:f190a6f3.0411031140.35d015e5@.posting.google.c om...
> 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|||On 3 Nov 2004 11:40:34 -0800, Michael wrote:

>I need to create a TempDB that that takes this table...
(snip)

Hi Michael,

I have just pested a reply to an identical copy of this question in
microsoft.public.sqlserver.programming. Please, don't post the same
question to several newsgroups.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

No comments:

Post a Comment