TheSQLGuru
3/19/2007 11:19:00 PM
SELECT CatID, Category, CatType, SUM(Amount)
FROM dbo.Category (NOLOCK)
GROUP BY CatID, Category, CatType
You can ORDER BY if desired, but avoid (for performance reasons) if not
required.
--
TheSQLGuru
President
Indicium Resources, Inc.
"RickSean" <RickSean@discussions.microsoft.com> wrote in message
news:EED7B0CC-F548-4DB9-9353-DAC402213C3C@microsoft.com...
> CREATE TABLE [dbo].[Category](
> [CatID] [varchar](20),
> [Category] [varchar](50) NULL,
> [CatType] [varchar](5),
> [Amount] [float] NULL
> ) ON [PRIMARY]
>
> insert into dbo.Category values('12345', 'C1', 'A', 2.55)
> insert into dbo.Category values('12345', 'C1', 'A', 3.22)
> insert into dbo.Category values('12345', 'C1', 'B', 1.75)
> insert into dbo.Category values('12345', 'C1', 'B', 4.15)
> insert into dbo.Category values('12345', 'C2', 'A', 1.99)
> insert into dbo.Category values('12345', 'C2', 'A', 5.50)
> insert into dbo.Category values('12345', 'C2', 'B', 4.19)
>
> I would like a sql script to return the following:
> CatID Category CatType Amount
> 12345 C1 A 5.77
> 12345 C1 B 5.90
> 12345 C2 A 7.49
> 12345 C2 B 4.19