Hi All,

I solved this problem a while ago with help from the group. I work with a relatively small data set for now, so this has worked perfectly fine...

I think the issue is that if you're looking at a char() or varchar() column, you always want to specify the data in quotes.

For example:

entercd not in ('031','032','033')

Wow! Thanks so much for the feedback, Greg, rbarryyoung and the others. I am working right now on compiling all of this into a working solution.

Note for rbarryyoung:...

I really appreciate that help!

My original solution was a table-valued function that basically did a where loop and subtracted a day every time there was still a null in the...

Interesting editorial, Steve. Reading between the lines, I think you’re saying project updates and meetings should be more focused to the relevant individuals. I agree with that part,...

Thanks for the tip. That should help quite a bit. I'll try to close the feedback loop when I get the solution.

While I'm sure there are companies that do this, the book shows the danger in this and provides a great argument for companies not being able to outsource this function....