Very cool.  Thanks Lynn 🙂

Thanks Jacob.  Along with John's link and your explanation I understand why there is a difference between the two results.

Thanks again Guys!

No, I haven't solved it 🙁

Thanks for the answers.  Unfortunately, it's an existing SP so I can't modify it.

This is what I get back from running the query:

class_desc    permission_name    state_desc    ObjectName    Grantee    Grantor
DATABASE    EXECUTE    GRANT    NULL    db_executor    dbo
SCHEMA    EXECUTE    GRANT    NULL    db_executor    dbo
DATABASE    CONNECT    GRANT    NULL    acli007    dbo

Thanks for your reply, Sue.

The only permission I gave db_executor is "GRANT EXECUTE TO [db_executor]"

Does it need more then that?

That was easy.  Thanks Andrew!

Thanks for your reply.

The 3 variables @dtEffective, @dtCurBus, and @dtsCstBasStart are being used within the SP after the SPs store the results in the variables.  Should that cause...

Didn't realize that's how the evaluation in SQL works.

Thanks.

Thanks Drew and Jacob.

I don't understand why the value becomes NULL if I don't provide the else condition.  I declared the variable with a default value of 0.

Thanks for your help, Drew.

You're right, there's nothing I can do about it.

Purely from a performance perspective, is the case statement faster compared to the ISNULL and Convert code?

The...

@dtStart -> int
@dtsStart -> datetime
@dtEffective -> int

Yes, it is.

Sorry, there isn't any source code that I have. It's more of a theoretical question. What's the best way to learn how these functions work behind the scenes? I...