how do you do a server side trace? and how will that effect production?

We did change when backups were happening so i'm pretty confident thats not it. The slow downs seem to be random.

We did run Perfmon and didn't see anything irregular.

Not...

thats what i figured. Thanks for your help

Yes in the pages and views they join together

we are working in 2008, could i unpivot the table to work with it better?

I thought about a merge statement too but was wondering if there was a more dynamic...

PerA, PerB etc are permission levels from 0-5. It is possible that the table is not created correctly this was created 8 years ago and is so ingrained in...

wouldn't i have 2 of the same user in the table then? I want to update the one line with results of the other but they are both in the...

How do i check?

its checked and grayed out

Awesome I got the code to work by adding in some master tables. Thanks for all your assistance and extra information. I have some studying to do.

WayneS (10/29/2010)

---

First of all, I'd recommend these two indexes (your code benefits from these also!):

CREATE INDEX [Cover1] ON [dbo].[aa_BillBillingAgreement](BaiOffice) INCLUDE (BaiPKey, AgrPKey);

CREATE INDEX [Cover1] ON [dbo].[aa_BillBillingAdjustments](BiaBillingDate, BiaInvoiceApproved, BiaStartDate) INCLUDE (BaiPKey,...

Will it cause any issues if we go back and index the tables?

Also what is the difference between the IsNull and Coalesce?

this is really cool code, would never have thought to do this. The one thing i'm missing is what happens if there is values in the previous month but...

What does indexing do? None of our tables are indexed. By doing the Create Index, what will that do?