Have you ever worked an issue with some vendors ahem early 2000's ahem and they don't bother to read your meticulously documented steps to describe and reproduce the issue, what...

To me, this is a process problem.

Management will need to support your efforts to work with the Development team, and the developers will need to agree to adopt an insert...

Lee Crain (5/19/2011)

---

After having read every post in this thread, I have to say that I pretty much agree and maybe even somewhat disagree with all of you. As a...

Totally and 100% agree. I'm sorry, I haven't used the NULLIF function before. Thanks for pointing it out; my toolbox now has a new toy! 😀

Only if you don't want nulls in the database, right?

That would totally depend upon...

I like this solution, though the numerics may give him some issues depending upon the datatypes in the table. In addition, an empty string may be undesired if NULL...

I do appreciate the article. I really do hope that the root cause of the corruption is explained.

I must say that in 5-ish years of 2005, 10-ish...

Eeep. I just saw how old this thread is. Zombie thread! YEAH!

Sorry 'bout that. And thank you for having the conversation.

And a full database restore in the middle of a development cycle wouldn't throw things off? I can't tell you how many times I've lost users, roles & permissions,...

I'm not actually disagreeing that developers who are supporting production enviornments need access to a version of production data. Of course they do - there, in fact, is really...

While its true that there is usually only a few columns that contain highly sensitive data, that isn't always the case. And it's not entirely the point. Once data or...