Can you create aggregate calculated columns in a table? Like a running sum?

I didn't think it possible, except via code based on triggers.

A query could do it,...

Seems Win 2000 uses named pipes, not shared memory, which must be just for win 9x.

Might the question or answer need some adjusting?

I think a more complete explanation would be nice. I quickly chose the popular TCP/IP, Named Pipes - thinking even if it's the other way around, I didn't care...

Must admit, while I know & follow the general concept of separating large, often joined tables in files on different physical disks (for improved performance due to physical drive I/O...

mccork - you remember your wife's birthday & anniversary? Wow, that's impressive. I use outlook's calendar to remember.

Hey, if anyone's interested, I have a challenging question - what...

Well...The purpose of the app is to manage railroad track assets (track charts). The select in question determines the video still to display, based on the location the user...

There's another reason for bit - legacy code. Even if tinyint will work, it's good to leave as bit to keep a reminder that the code won't handle other...

Thanks for the response - here is some more info: I would love to have a stored procedure, but there's a problem: I can't change the app. There...

Nah, this wasn't as good as the last.

Can't see many arguments about this one.

Wow! 7 topics & nearly 100 posts on a single QOD!

I put in my 2 cents a while back in TomBrattin's topic, but a few things stand out -...

This actually is QOD 11/21

I agree the question is contrived (no context, no joins to consider), but for the info given, I thought the answer was clear. As for...

"With Ties" is one of the things learned right at the start, but use so infrequently it's easy to forget.

Thanks for reminding me.

I need another bit of key info: What is a blackbox

"Returns the computer name of the who is running the query." is correct, even if the English syntax is bad. "Returns your SQL Server's computer name" is wrong...

Yes, the question was changed on the web page. Don't you also see the red warning message above the QOD?

Maybe the best answer was to upgrade to sp3 &...