Do I hear an "Amen!"?

I'll make you a deal. You don't call me Tom and I won't call you Jef....

rbarryyoung (8/27/2008)

---

...Noel's query (and I think that yours is the same) is assign the count difference to the wrong time/record. It is supposed to be assinging the count difference...

rbarryyoung (8/27/2008)

---

Yeah, I've been playing around with a version like that one, Noel. Except that I think that you have the A's & B's reversed: you are reporting...

To really make a test, I loaded up the table. After loading in the first 25 rows of the supplied data (I left out the rows that didn't change amounts),...

Jeff, you are correct. However, I have to avoid things like CTEs. Not because I have anything against them but because 90% of my dbs are still SS2k, not to...

Actually, the code was "60 * 60" not "3600", meaning 60 minutes per hour times 60 seconds...

I don't know if this is any faster than Jeff's (he being the King of Nasty Fast), but it doesn't use any string manipulation (which I try to avoid if...

Here is my contribution:

declare @ShiftCountersRawData table(

RecID int IDENTITY(1,1) NOT NULL,

...

john.arnott (8/22/2008)

---

Does your solution depend on the temp table being read back in the same order in which it was loaded? That "gotcha" would have to be avoided at least...

Interesting problem.

declare @Table table(

RowID int Identity(1,1),

CustNo ...

declare @Table table(

ID int not null,

Dep money,

Accum ...

I've always said that if I was charged with developing a top-notch Accounting application, I would hire a top-notch Accountant who knew squat about programming and a top-notch Programmer who...

Why? I'm assuming the table had a...

You looked just at the "create table" script and decided that the table needed indexes? That is impressive. I generally have to look at the queries to make that determination.

And...