I hired one programmer with a pedigree and an entire wall of certifications. No problem with any interview question either. Problem was, he couldn't produce unless I sat on him...

This bring back too many dark memories! I worked on IBM 360/370 mainframe hardware when I was in high school - installs and upgrades mostly. One thing we needed to...

Yup, Jesper's way is the most efficient if the update has a higher probability of occurring than the insert. Alternately, if you try the insert and use any dupe-key error to invoke...

You can use most carrier's SMTP interface to send SMS messages (they will cut you off if you whack them hard). Naturally you must know the carrier of your target...

You've got to step into OpenCustomers() and see what's null  there.

You can even use a recordset returned by one sp in another sp, as shown below. This is useful when you have some common select logic you don't want to maintain...