As a fellow consultant, I feel it is our duty to present the options. Perhaps advocate strongly for one, but only in as much as it is what the client...

Good point. It is not just the people "looking in" that caused the confusion.

[RANT] It is not the label (DBA) that is the problem. It is the people using the label. DBA - "DataBase Administrator". Definition "Administrator": some one who manages. It does...

It goes to perspective. "Have I failed in my career?", I don't know, my career is not over yet. Have I had failures in my career? Sure, those set backs...

I think you need both. I was classically trained, if there is such a thing in computer science, with theory and all. I work with too many "home grown" developers...

We We! 😛

Thanks. You both helped my understanding of this subject, as well as providing me with the resolution.

So the user is part of the "schemas" db_writers and db_reader. Should I just grant execute to one of those? (Sorry, even after reading up on SQL Server schemas I...

I would tell them to be nice to people. Recognize the small and big players you encounter everyday. Being helpful doesn't ever hurt you. Regardless of what you chose to...

I usually do a "replace" [ with nothing, and ] with nothing, just tedious.

Thanks.

Alas ignorance, possibly just not thinking it through, but most likely ignorance.:blush:

Luis Cazares (4/8/2014)

---

Since you're correcting this code, why don't we make it simpler and faster?

This way you read the table just once instead of trice. It's also a lot less...

Arrgh. Sorry. I keep thinking those are input parameters, not output.

Another issue I had is that you can not just "compile" (execute) a CTE definition by itself without some follow...

Another good thing to know.

Is that because of a performance hit?

OK. That is a good thing I guess. Evidently one of the other admins turned that on. I was concerned that maybe they started appearing because SQL Server "thought" there...