The only thing I can think of is that there's some difference between what's in the job and what you're running manually. Either a different date or possibly something...

How are you testing this in the job? Running the select to confirm there are rows then immediately running the job?

And do you know no rows were deleted or...

EDITED: Ooops. Missed page 2 so my post isn't relevant.

Will every row have at least two leading 0s?

A tally table is something that you need to generate. Here's an article about it including several scripts to create it:

http://www.sqlservercentral.com/articles/T-SQL/62867/

Profiler itself wouldn't be bothered by it but the queries that you run may. I know with the application I support there is a good chance that will cause...

I can't think of a way to do this from within SQL but we've done similar stuff in our application from the client side. You can just have the...

That will be all user created stats including those for indexes.

I should have also pointed out earlier that while it is possible to drop system created stats SQL created them...

It's possible

select count(*) from sys.stats where auto_created = 1

1804

drop statistics tablename._WA_Sys_00000002_00750D23

select count(*) from sys.stats where auto_created = 1

1803

Right now this appears to be the only way to combine the current and previous tables to get the output you suggested:

select c.invoicedate, c.sales, p.sales_py

from #Current c

inner join #Previous p

on...

Profiler is going to be more useful in tracking down the problem if there is one because it will let you see what's actually running. If Naigos lets you...

This should be what you're looking for. If not we'll need some more information like Wayne said. There's a link in his signature on getting better assistance that...

I would focus on RPC Completed and Batch Completed.

Why did high level management pick those numbers? Was it based on trends seen on the system that's being monitored or...

From what I'm seeing the code that Kingston posted is working fine. The only difference I'm seeing between what his query returns and what you expect is in the...

ben.mcintyre (4/7/2010)

---

While I agree with the sentiment of this article, I think the most important thing is: if you DO change any data, KEEP AN AUDIT TRAIL ! You...