I use the technique described in the Guru's Guide to Transact-SQL for this type of issue. You can find the solution reprinted here:

http://www.sqlteam.com/article/calculating-running-totals

This may sound like a stupid question but are you executing the procedure or executing the code you listed there to alter the procedure?

You can use either the OR statement or use ISNULL() or COALESCE(). I like ISNULL for readability, personally. However my understanding is that it can cause stored procedure...

No because computed columns by default are not actually stored (this can be changed). Your better option then is to use a default value. You can reference a...

Create the other column as a computed column. Look up computed columns in BoL.

No problem. I was just totally confused by your terminology.

What you want to do is set the column to be an identity column first. You can do this...

To quote Inigo Montoya in The Princess Bride: You keep using that word. I do not think it means what you think it means.

I think you're talking about something other...

The way I did something like this was this way:

SELECTCOUNT(CASE WHEN YEAR(myDate) = 2000 THEN 1 ELSE NULL END) AS Count2000

That's actually going to be a machine within your network. You're better off doing an nslookup of that IP address to see the machine trying to make the connection.

If I only needed to do it once, I'd probably extract it and use perl because it's much better at regular expressions. I was able to come up with...

My understanding is that IE passes windows authentication information in a way that Mozilla doesn't support at this time. So it will prompt you for your username/pw and then...

Could be an execution plan compilation issue, but it still shouldn't take that long for a simple insert. In the database properties dialog box is the Auto Close option...

In SQL Server 2005 you can use the ranking functions (look em up in BOL) to do it.

It's called dynamic SQL... basically it just means that you built your SQL string on the fly and executed it. It has it's up sides (flexibility) and it's...

There's a lot of discussion on the best way to do this. My understanding is that if you're feeling lazy, do this:

CONVERT(DATETIME, CONVERT(VARCHAR, GETDATE(), 101))

However the better performing method...