Have you checked index fragmentation? Have you updated statistics?

How many CPUs/cores on the new box?

Can you see what happens if you set MAXDOP = 1 to the query? ...

Joe,

I believe the OP needs a view that shows both PL and BS amounts in YTD, but the calculation is only needed for the PL amounts. Also, the OP...

I have them all.

Great. How'd you fix issue 2?

Hey Lynn, how's the new job going?

bitbucket-25253 (3/8/2012)

Evil Kraig F (3/8/2012)

I want two... I know...

Yup that works and I considered the conversion to INT as well, but that means you are assuming that the vehicleid is always the same with a a 0 or...

I believe issue 1 can be fixed by adding the report server to trusted sites in IE.

I don't know what's happening with issue 2. Can you post the...

Thanks guys. I got mine about 2 minutes AFTER I posted about it here. Usually it is waiting in my inbox when I wake up, so I have...

If you have AV on the server, check to make sure the DataBaseMail.exe is not being blocked. McAfee blocks it by default in the mass mailing rule and it...

Something like this should work for you:

DECLARE @tableA TABLE

(

vehicleID VARCHAR(5),

[timestamp] DATETIME,

...

Test email worked?

Are there any errors in the database mail log?

Has anyone gotten the newsletter today? I have not and I keep getting a notification email for the same post.

Not to be downer on rolling your own solution, you also need to take into account the time to develop, refine, and support the solution you create, which often times...

I don't think that there is a way to do this. I think you'd be better off going with a file configuration and deploying the file with the package...