Thanks for the verification, that puts my worries to rest -

Now I’m guessing that with Instant File Initialization turned on, it may simply be allocating the new space rather than...

Handy for baking in aggregates for use in Reporting Services datasets:

use AdventureWorks2008

go

select

lastname + ', ' + firstname RepName

, CountryRegionName

, StateProvinceName

, COUNT(*) OVER(PARTITION BY CountryRegionName) RepsPerCountry

,...

This is a decent workaround for something SQL Server doesn't seem to adequately support (afaik): temporal awareness

Not to plug another rdbms, but the one starting with "p" has gone a...

hmm... seeing that my data is in Access and the recordsets are pretty light, I may opt to keep everything local with the VBA cursor on a custom function.

Otherwise I'd...

Ok, thanks for the confirm - now I'll have my work cut out for me trying to build a solution with ADO slinging around recordsets between Access and SQL Server!

<obligatory newbie double-post above>

Thanks David - that was quick! I'll have a go at translating this into VBA and see what happens.

Although it does look like there's no way around firing a...

Thanks David - that was quick! I'll have a go at translating this into VBA and see what happens.

Although it does look like there's no way around firing a...

Tally Tables are the bomb, and confirm my own intuitions regarding the power of set-based operations. Many thanks, Jeff!

Now I have another poser for you or anyone else -...