Problem with Subquery, group by

[Kristen]

is this the same question as

Derived Column Problems

Im needing to create a derived column that takes unique customerids and sums up the instances of certain statuses in an orders table (and eventually do a rollup grandtotal) : TABLE dbo.orders --o ( OrderID (pk, int, NOT NULL), CustomerID varchar(5) NOT NULL, Sourceid (pk uniqueidentifier NOT NULL), Status varchar(50) null, Ordershipped datetime NULL, Orderarrived datetime NULL CONSTRAINT PK_OrderID PRIMARY KEY CLUSTERED (OrderID ASC) ); TABLE dbo.customers --cu ( CustomerID (pk,varc…

if so It would be better to continue that thread to keep it in context.