I am using a Red Gate tool Data Compare to move the data between two testing environments. Some of the indexes on one box were updated with REBUILD WITH...

For performance would it be better to handle the YTD sum using a WHERE clause in the SELECT or is good to just do it in CASE statement

Sorry for being vague I know I need the group by.

Select user, sum(sales) ytd, sum(sales) today

where salesdate>user.Startdate

group by user

This give me the users year to date sales but I...

Can you go into more detail, I don't thing I fully understand.

Thank you

Yes that is what I mean in DB1 it has the proc myProc.

I need the database to used to be either DB2 or DB3 after the data has been...