@strMode as varchar(2), @TMID as int=null, @UsersID as int=null, @ClassID as int=null, @AAID as int=null if(@strMode='MA') begin select A.Que_ID,A.Ans_ID,A.Ans_Answer,A.Ans_FileName,(select Ans_Answer from Answer where Ans_ID=cast(AD.ADD_Answers as int)and Q.Que_Type=3 and(AD.ADD_Answers<>'true' or AD.ADD_Answers<>'false')) as studentanswer,Q.Que_Type,Q.Que_Group,TD.TS_ID from ActivityDoneDetails AD inner join TestDetails TD on TD.Que_ID=AD.Que_ID and AD.AA_ID=@AAID and AD.Users_ID=@UsersID left outer join Question Q on TD.Que_ID=Q.Que_ID left outer join Answer A on Q.Que_Id=A.Que_ID where TD.TM_ID=@TMID and (Q.Que_Type=3) and Q.Que_IsDeleted=0 end When executing the stored procedure an error comes like this:<pre lang="text">conversion failed when converting the varchar value 'True' to int.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)