use a "minutes" table, or create one in your CTE like Frederico did, I like Jeremiah Peschka's solution here: http://facility9.com/2010/02/24/rounding-to-the-nearest-x-minutes

I completely agree with you, Steve. At my previous job we used Visual SourceSafe (VSS). We struggled to try and use TFS, but never got it right, so we...

have to admit, I was at the grocery store this morning and a guy had on a TSA jacket, so I turned around and went to another aisle....

It's not really about us (younger than older folks with no complications) although nobody wants to get sick. it's about us accidentally passing it from PersonA (who doesn't know they...

It has happened. people from Wuhan didn't go straight home, they went to the air force base. Cruise ships didn't let people off.

People won't like it, but if it's bad...

I find the pattern to follow the following rules:

1. usually folks on the west coast like to interrupt you right before/during your lunch and dinner hours.
2. it happens mostly during...

"Thank you for your kind donation to the local high school band program, in appreciation of your gift, a brick with your name has been placed on the entrance to...

True, I am MUCH more productive at home. YMMV

You simply do your best. If you are not allowed to use all the tools, then you use what you can and ask for help when you need it. but...

I have had to pass the parameter in to an internal variable that matches it exactly, and just assigns the value over. That made a HUGE difference when I did...

well that was a rollercoaster.

I had not noticed that tidbit in the documentation, and was all "aw, crap!"

Then I kept reading, and went "maybe I should test..."

but you guys did,...

This is akin to asking "whose responsibility is it to provide a quality product"?

Everyone's responsibility should be to make their work the best they can, not depend on other people...

I have been the victim of some cancellations. My band was going to be playing at SXSW again this year. That was cancelled. That in itself isn't a huge...

You also don't seem to know the status uses a nominal scale and therefore cannot be a numeric value.

Status only uses a nominal scale if someone decides to include the...

Chris is right about the code comments there about redundancy, although I wouldn't do the comparison on Auth_number like that, because lots of times they are not numeric, they might...