I realize this is a very, very late reply.  I wasn't able to get back to the stored procedure right away.  However, your answers did help me get rid of...

Here's a related article.  https://blog.greglow.com/2019/08/06/opinion-the-best-apps-tolerate-user-mistakes/?utm_source=ssc&utm_medium=pubemail

Coincidentally, I started reading a fiction book last night where an editor was musing on how some computer programs are not forgiving.

"The old certainties of typescript, of pen and ink,...

To see if anyone is paying attention.

Sounds like an interesting book.

Took a 4-day trip to Holland, Michigan with my mom.  2 drive days + 2 full days.

Summer movie series at the beautiful Ohio Theater.  Only $3 a ticket with a...

Thanks.  I was familiar with Set Statistics Time and Set Statistics IO, but hadn't run into Set Statistics Profile.  Gives me one more tool to work with.

I haven't used these yet.  Just wondering, what are some of the things people in this group have used Service Broker queues for?

Same.

(This was meant to be in reply to TOM_HOGAN who said "Got it wrong but the explanation was excellent." But I hit the wrong reply button.)

• This reply was modified 5 years, 10 months ago by  Marcia J.

I think the above two replies are enough to get me going.  Unfortunately, I have to work on another urgent problem.  But once I get back to this and try...

I hope that forgiveness is possible for those who have really changed and are sincerely sorry (not a "I'm sorry I got caught and it's really someone else's fault" type...