Thanks for your help. I changed the code, however I ran the stored proc and get an error.
Parameters Used: 'Custodian', 'Escalation', 'MLCO'
The error message displayed is:
Conversion failed when converting the varchar value 'MLCO' to data type int
What does this code mean? "else 0 end = @ID" Could this be the issue? Thanks.
Heather