So my weekly backup ran after I changed the job owner to "sa". It still ran under the NT Authority account though.

Ok, I changed the job ownership to sa. I had just left the ownership as the domain administrator because that was what my predecessor did and I didn't know...

1. The backup code (or is this only in maintenance plans).

It is just a maintenance plan Full backup

2. What is the "run...

I'm trying to restore to the same system I did the backup from. Both the Sql Server and the Agent run under the same account.

Thank you very much this really helped me understand what is going on. I really appreciate the help and the clarity of your answer.

Nathan

That is what I figured however in order to know what filter to apply to the select statement I have to know what the CTE is doing to make sure...

Toby,

I considered the conflicting permissions idea. The probelm with that is she is a member of the same domain groups as many other users. Also I control all...

Sorry for the late reply I was out of town for awhile. So I took your advice and logged on to the server with management studio as her and...

Thats the funny thing about decimal places. Technically, you are both right. Obviously Jeff's higher precision datatype leads to a more mathematically accurate answer. At the same...

Nope DECIMAL(19,12)

I just wanted to let everyone know how things went. I have to say I learned a lot about the different ways to solve this problem. All three...

I'm overwhelmed with all the help. When I first posted this problem I figured it might be quite some time if ever that someone came up with a solution....

Currently there is no running balance column in the table. If I need to add one let me know. I also have no indexes at this point. ...

Yeah I'm working with refunds so refund=amount. I have 222K rows of data which comes out to about 11K accounts. I will definatly be interested to see your...

Well after 1 hour and 11 minutes it reached the maximum recursion of 32767 and terminated. I'm going to try and figure out what exactly this query is doing...