Huh, I always assumed that we did run AV on the server boxes. Went to check, and it appears that we don't. It doesn't alarm me, since the servers are...

Lynn Pettis (2/9/2009)

---

Olga B (2/9/2009)

---

Great article. The best thing about the suggested approach is that if the poster takes the time to define the problem and consider the test data...

Great article. The best thing about the suggested approach is that if the poster takes the time to define the problem and consider the test data and the desired output,...

A simple solution would be to make a history reports that saves the previous reports totals and redisplays them... then the export becomes a breeze.

Or the user can always copy...

I do think Prometheus is an apt comparison. Some days, you feel like you bring fire into the dark corners of the organization and make things better and brighter. Other...

I'm getting this error message on the backup job that ran happily for over two months. It's backup only on a bunch of databases, no integrity checks or optimization, no...

Not an oxymoron, but I cracked up when a consultant used "we will reach out to you" to mean they would email the meeting minutes.

Wayne West (7/25/2008)

---

I wouldn't say that a lot of Americans are cultural morons, but they definitely can be culturally ignorant. Definitely too many Americans assume that the rest of...

The list of answers was incomplete!:hehe: Here, a backup failed (although for a perfectly logical reason and I was able to rerun it).

Excellent question. I learned something useful.

One application of OVER that seems to have potential (note hedging 😉 ) is that it allows applying aggregate function to more than one different...

That's great!

Er... is "ask" a noun now? Is "request" being discontinued? 😉

What about adding computed columns to a view and running reports on a view? No increased data size and easier reporting.

I may have gotten it wrong if the question were not sponsored. 😉

OK, this is a corrected version of the query, which works with 0, 1, 2, or more ~s in the column. The select returns everything after the second to last...

But looks like I am. How on Earth did I miss it?

Anyway, thanks for sharing the solution.