Thanks for your comments, I'm glad to know what approach is best.

FYI, what I use it mostly for is a lookup table. For example, "gender" is stored as 1 or...

Thanks for your input, it's much appreciated!

🙂

Thanks again Michael (and others)

My preference indeed is to skip the conditionals and the dynamics. On the other hand, the number of stored procedures would run into the 100's. I...

Thanks Michael, it looks like this will indeed solve the issue.

One question though: you say you "don't advocate adding procedures to the Master database". Can there be serious problems doing...