Hey -

I think that it's possible that my backup chain may have been corrupted by some transaction logs being removed by other people. The server is working perfectly fine...

Thanks for the link, Lynn. That clarifies a lot.

If I understood correctly, the fact that I had not enabled transaction log backups on my system meant that A), the system...

Yeah - I was kinda hoping to avoid having to write a series of SELECT statements, either using pivots or cross-tabs, and UNIONing them together, but if that's the only...

Cool - so I was messing around, and found that the best way of being able to get my actual results was to run an SSIS package that would export...

Hmm. Hadn't thought of using APPLY. Thanks for the heads up, I'll give it a shot.

Figured it out - As you were suggesting, I had already created the credential and was using the proxy. The problem was that the proxy account was not a member...

Okay, got a bit more info now ... Pretty sure the problem is that the SQL Server account doesn't have permissions to run the scheduled task itself, not the batch...

@Lynn - that was actually something I was thinking about too, for that exact reason. As it stands I'm going to have to modify the other tables one...

Yeah I figured the same as well, just wanted to make sure I was correct in that opinion before going ahead with it.

On a related note, if you have a...

The second query provides the correct results from my example set, but here they are anyway:

ClientIDNumAccountsNumPurchasesAmtPurchases

144180.00

2341400.00

You can use them as default values? oh that's cool - I was wondering where this feature would be usable. I can see that coming in handy for sure. Thanks!

Sounds good - finished all of that, took about 30-60 minutes, not too bad.

One thing I'm not sure of though - since I didn't restore the system databases, does that...

I was considering the option of having it be an extra column but if I ever want to make those extra answers usable as future choices, I would need to...

Man, I almost wish you hadn't suggested that Sean. I was quite happy with the solution I had devised, then you have to go and suggest a better idea to...

Interesting. Hadn't really thought about it like that. So, for getting the values afterwards, I'd use some sort of dynamic cross-tab? Interesting ... gonna need to think about that.