create a log table, and have the proc write the parameters it receives to the log. you're probably not getting what you expect.

also, if you only have 2 roles, use 'Manager' as a boolean comparison

if (role = 'Manager')

do this

else

do that

rather than a case

if (role = 'Manager')

do this

if (role = 'SalesRep')

do that