• 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

    Heather B....