Wouldn't you want to use a case statement like this to divide by 1 if the backup date range is 1 day?

select
database_name,

If you have a query already that returns the region and product line, the you could try the query below using sql servers OVER clause to partition the sums by...

I'm a Windows Server admin and I can tell you that is most likely what happened.  It's possible the domain changed in some way and invalidated your GUID in the...

The first result is the record before the update.  The second result is the record afterwards.
Also, i can't normalize the table. 

ChrisM,

 We're going to move to the new version of our EDI software.  The engineers I've been working with are telling me the indexes we've been looking at are...

You ever use DTA much?  Here is what it output as index recommendations.

The query completes in 46 sec. with both indexes, which is weird b/c it completed in 42 sec with only the second index you gave me. Hmmm.  Ive attached the...

Is that index dependent on the previous index you gave me?  I've been removing them between tests.

Created the index and ran the query.  Took 42 sec.  The date is Dec 01.

Took me a sec to figure out how to get that. lol. I'm definitely a SQL server novice. Thanks for all the help.

That index gives me a marked improvement.  Query time goes from 1:07 to 0:29.  But something still doesn't seem right b/c if i remove the 'AND p.DGID = std.DGID' part,...

This is the only index/key on the table now.  It seems to already contain the DGID column.

ALTER TABLE [dbo].[Partner] ADD CONSTRAINT [PK_Partner] PRIMARY KEY...

I wouldn't need an index on the EDIStdDocs DGID column?

I guess i should ask what i can do to be able to add the 'AND p.DGID = std.DGID' back to the query.  Do i need to add an index...

ChrisM@Work - Your query works great now.  Pretty sure i found the issue.  I did have to change 'COUNT(TP_PartID)' to 'COUNT(p.TP_PartID)' to fix an ambiguous name error.
The main...