Can't figure why the GROUP BY is not there.
the stored proc I copied the code from contains:
select $Partition.AccountBalanceDate(AccountBalanceDate) Partition, COUNT(1) RecordsPerPartition
from AccountBalanceMonthEnd with(nolock)
where $Partition.AccountBalanceDate(AccountBalanceDate) between 22 and 25
group by $Partition.AccountBalanceDate(AccountBalanceDate)
order by 1
could one of the admins at SSC please fix this?
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”