Declare @Subject Table(--Topic Table VariablesSubjectidint, Questionnvarchar(MAX), Correctanswervarchar( -), Explainnvarchar(MAX), Subjecttypeidint, Createidint, CreateDatedatetime, Subjectscoredecimal(3,1), Scoresortint)Insert into @Subject(Subjectid,question,correctanswer,explain,subjecttypeid,createid,createdate,subjectscore,scoresort)SelectA.subjectid,a.question,a.correctanswer,a.explain,a.subjecttypeid,a.createid,a.createdate,a.subjectscore,a. Scoresort from (--List of topics (incoming parameter Histpaperid,subjecttitleid) SelectA.subjectid,question,answer asCorrectanswer,explain,typeid asSubjecttypeid,a.createid,createdate,score asSubjectscore,sort asScoresort fromHistpapersubject a Left JoinHistpapersubjectscore b onA.subjectid=B.subjectidwhereA.isdel=0 andA.histpaperid= - andB.histpaperid= - andB.subjecttitleid=193) ASelect * from @Subject
SQL inserts the result set of a query into a table variable at once