BEGIN TRANSACTION; SELECT ROW_NUMBER() OVER (ORDER BY cat1DisplayORder, cat2DisplayORder, QuestionOrder, ResponseOrder) AS Row, Question, Response FROM tblJobPromo j INNER JOIN dbo.tblJobProfile jp ON j.fkJobId = jp.fkJobId INNER JOIN dbo.view_PromonetProfileQuestionResponses pr ON pr.responseid= jp.fkProfileResponseId WHERE JobPromoId = @JobPromoId AND Response <> 'N/A' AND questionid NOT IN (37,38) AND ResponseID <> 62 AND QuestionID <> 1868 ORDER BY cat1DisplayORder, cat2DisplayORder, QuestionOrder, ResponseOrder COMMIT TRANSACTION;
AND Response <> 'N/A' AND questionid NOT IN (37,38,1868)AND ResponseID <> 62
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)