Grass (4/14/2012)
I think I actually found out which part of the code is giving the error. It is on the first two SET statements when I pass the three variables @Project_Id, @Matter_Id, and Project_Desc.Do you think I can rewrite that section of SET statements then it might work?Thanks.
Yes. Try using Select Distinct or Select 1 in those SET statements.