Bob,

I don't do that because that would include non-business days. the -21 was just a filter to cut off a large portion of the table that wouldnt be used....

Understandable.

This is a portion of the select statement using these columns. We will be building reports, and these columns represent the last 14 business days, and they are summarizing...

Oh this works fine, I was just trying to get this done in one select statement vs doing a CTE followed up by 14 sub queries.

It is an ad hoc query that will be turned into a stored procedure once we weed out the performance issues 🙂

got it.

I did just that and yes the performance is the exact same.

I did check the execution plan before however, and the Clustered index on the View was...

Drop and rebuild the Indexed view so it is just a view? I didn't quite all understand that one 😀

We are using SQL Server 2005 Standard Edition.

We have a massive fact table that contains Invoices on a very granular level. The indexed view aggregates much of this into...

Thank you for the ino on this guys that helps greatly!

Yeah I tend to agree with that. I just wanted to make sure my thought process on that was right, or possibly if there were other solutions I wasn't thinking...

Awesome thank you for the info! I definitely need to read up on this when I get the chance.

Sorry for the slow response Bruce, been a busy week!

I use an SSIS ETL process. We have a staging database that gets wiped and reloaded each night from an as400...

Awesome thanks Jeffrey. And I guess since you are a SSC Crazy you would know :).

I do admit I need to research more on recovery models, back ups and...

Thank you for the help Jeff I appreciate it 😀

Here is the code that creates the table. There are no primary keys but here is the create table and index code. (Note on the create table, I did not...

I am working on a copy I moved into my development environment and before I even started the code I added the indexes I figured were necessary 😉