Yep, a bad cut and paste on my part

That's good to hear! It's the only one I have left. Of the 441, 443, 444 exams, I thought 441 was the hardest, but I took that last year in...

That's probably funny until it's your wife in silk that needs to wash her hands.

Be lots of manure shoveling for me if I try that one

Excellent! Define requirements might be step 5, but more likely step 6.

We're rewriting and the developers have this thread in their list of stuff to do, so we'll see. At the very least we'll let you set your timezone

OK, just got me with the explanation and I forgot the copy/paste.

Doh!

OK, the word from my hot new UK developers with lots of .NET and ASP experience is that it's...

The keyboard ones are funny for people that don't know their keys. While I'm not a touch typist, my fingers have a lot of memory from years of typing and...

I was hoping this would turn into more of a DBA debate on why we as a group of professionals get so worked up about various topics. Lately I've followed...

Lowell, our apologies.

It's can't be a simple timeout, but must be some intermittent error. I haven't seen it for months, but it happened this week to me and I was...

full outer join?

Move your stored procedure to a function

Or write a query to do the calculation and join to the view.

Grant's explanation makes sense. It looks like you're using a temp table as well, so that will get created in tempdb along with any other intermediate tables that SQL Server...

Implicit conversions can get you in many places. The big thing to be aware of is that you'd probably want to compare > 0.0 so that the conversion doesn't take...

Maybe you can give an example with data? Not really sure what you're looking for.

Are you trying to move the structures or the diagram?