...and yes that table does exist in the cicp db.

Here is my last foreseeable question for now...

When I run these statements....

DROP TABLE cicp.dbo.NewShippers

GO

create table cicp.dbo.NewShippers (Phone NVARCHAR(15) PRIMARY KEY)

INSERT INTO cicp.dbo.NewShippers (Phone) SELECT Northwind.dbo.Shippers.Phone FROM Northwind.dbo.Shippers

....I get this message....

Server:...

Thanks for the response Ben.

When I use...

SELECT Northwind.dbo.Shippers.Phone

INTO cicp.dbo.NewShippers

FROM Northwind.dbo.Shippers,

cicp.dbo.NewShippers

...by itself without the create table statement, I get...

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'cicp.dbo.NewShippers'.

------------------------------------

Thanks for...

The last time I used sum() on a different report, it summed up all charges throughout the report (not just the record level sum() ) and entered that one amount...

Everytime I include the a group by on that column ('Count'), every charge code is listed exactly 45 times and the count is different on every line and I have...