Dynamic select query

Question

I want To make a sql Query Dynamic mean On if else Condition i want to Add different columns into the select statement like that
If(QuestionID==1)
Select some thing
Else IF(questionID=2)
Select some thing differnt

Danish Habib · Answer

You gave me the good solution i have that procedure already and I want to concatinate new variables with the @Query values based on condition. ---- exec spGetRecord 1 ALTER PROCEDURE [dbo].[spGetRecord] @QuestionID INT AS BEGIN DECLARE @Query nvarchar(max) DECLARE @MenTarget nvarchar(10) DECLARE @WomenTarget nvarchar(10) DECLARE @BoyTarget nvarchar(10) DECLARE @GirlTarget nvarchar(10) --SELECT @MenTarget = SET @Query = ' SELECT A.AnswerId,CdfPErsonName, A.Year, A.Quarter, QT.QuestionTarget FROM Answers AS A INNER JOIN QuestionTarget AS QT ' IF(@QuestionID = 1) SET @Query = @Query + 'ON A.Question01 = QT.Question_ID AND QT.QuestionTarget = A.Question01Target' ELSE IF(@QuestionID = 2) SET @Query = @Query + 'ON A.Question02 = QT.Question_ID AND QT.QuestionTarget = A.Question02Target' ELSE IF(@QuestionID = 3) SET @Query = @Query + 'ON A.Question03 = QT.Question_ID' ELSE IF(@QuestionID = 4) SET @Query = @Query + 'ON A.Question04 = QT.Question_ID' ELSE IF(@QuestionID = 5) SET @Query = @Query + 'ON A.Question05 = QT.Question_ID' ELSE IF(@QuestionID = 6) SET @Query = @Query + 'ON A.Question06 = QT.Question_ID' ELSE IF(@QuestionID = 7) SET @Query = @Query + 'ON A.Question07 = QT.Question_ID' ELSE IF(@QuestionID = 8) SET @Query = @Query + 'ON A.Question08 = QT.Question_ID' ELSE IF(@QuestionID = 9) SET @Query = @Query + 'ON A.Question09 = QT.Question_ID' ELSE IF(@QuestionID = 10) SET @Query = @Query + 'ON A.Question10 = QT.Question_ID' ELSE IF(@QuestionID = 11) SET @Query = @Query + 'ON A.Question11 = QT.Question_ID' ELSE IF(@QuestionID = 12) SET @Query = @Query + 'ON A.Question12 = QT.Question_ID' ELSE IF(@QuestionID = 13) SET @Query = @Query + 'ON A.Question13 = QT.Question_ID' ELSE IF(@QuestionID = 14) SET @Query = @Query + 'ON A.Question14 = QT.Question_ID' ELSE IF(@QuestionID = 16) SET @Query = @Query + 'ON A.Question16 = QT.Question_ID' SET @Query = @Query + ' WHERE QT.Question_ID ='+ CAST(@QuestionID as nvarchar(10)) EXECUTE (@Query) END After checking the condition i want to add some more columns on select statement

Joginder Banger · Answer

Hi Danish Habib, Make the store Procedure like this type. create procedure Procedure_name ( @firstParameters varchar(max), @secondParamerts varchar(max) ) as begin if(@firstParameters=='condition one') begin --do stuff here end else if(@secondparamerts=='condition two') begin --do stuff here end end end

Khargesh Rajput · Answer

If(QuestionID==1) Select * from table where QuestionID=1 Else IF(questionID=2) Select * from table where QuestionID=2

Dynamic select query

Answers (3)