Why do you want a cumulative update on fine each day?

It's easier to just query for that information, and you don't have to mess around with permanently storing a derived...

Nice, so then my guess was right on the nail 🙂

...and the anser to the op is; No, there is no risk of memoryleaks or 'runaway' multiples of overwritten variables...

So, what's the deal with not having a dates table?

It will solve all your problems, no need for complex functions or anything else exotic.

The main problem: How do you define...

😉

Look at the top.

The declaration of @p is inside the while loop.

...unless you're really asking for something else? 😎

T-SQL does. 😀

Just being picky, but...

There's no such thing as a LEFT JOIN being 'equivalent' to an INNER JOIN.

Those are quite different, different questions asking for different answers and works in...

Well, haven't given it much thought actually.

I routinely never declare/create/drop stuff inside loops unless restricted by scope or forced to do it for some reason. For the 'normal' stuff, I...

On the top of my head I can only come up with one op that is 100% write (or almost anyways), and that's an INSERT statement. (in the database data...

Well... Don't you think that RAID5 gives just that - 'most perf bang per buck'..?

I mean it's a relative between the perf given compared to the bucks it's costing... 🙂

And...

Does 'sp_get_log_shipping_monitor_info' give you what you need?

/Kenneth

My guess is that it won't be declared more than once, after the first time it's decalred, only the assignment will happen.

I'm guessing this due to the fact you can't...

Matt Miller (10/16/2007)

---

Actually - I'd avoid Raid 5 altogether when dealing with SQL Server. Raid 1 or Raid 10 are the way to go. RAID5 has too much...

If the mission is to find some sort of 'evidence' of a certain action, then providing the db is not in simple recovery mode, the transaction log contains records of...

The 'problem' with financial systems is that they all too often use floats.. And expect them to be 'reliable'. Wrong tool for the wrong purpose.

/Kenneth

This is one of the 'fun' parts with dates and calendars. When you say 'anyone', in places...