I want to dynamically load the last part of my WHERE clause by placing the variable @Wcl in place of the AND (dbo.Sections.SectionID = 13) AND (dbo.CJQDetail.ResponseID >= 76 AND dbo.CJQDetail.ResponseID <= 78)WHERE clause like so: Can it be done?declare @WCl varchar(100)set @Wcl = 'AND (dbo.CJQDetail.ResponseID >= 76 AND dbo.CJQDetail.ResponseID <= 78)'SELECT COUNT(dbo.Response.QuestionID) AS ResponsesFound, dbo.Response.QuestionID, dbo.CJQDetail.CJQID, dbo.Questions.SectionID, dbo.Sections.SectionName, dbo.Questions.MinResponse, dbo.Sections.FormID, dbo.Sections.AspPageNum, dbo.Questions.QuestionID AS Expr1, dbo.CJQDetail.ResponseIDFROM dbo.CJQDetail INNER JOIN dbo.Response ON dbo.CJQDetail.ResponseID = dbo.Response.ResponseID AND dbo.CJQDetail.ResponseID = dbo.Response.ResponseID INNER JOIN dbo.Questions ON dbo.Response.QuestionID = dbo.Questions.QuestionID INNER JOIN dbo.Sections ON dbo.Questions.SectionID = dbo.Sections.SectionIDGROUP BY dbo.Response.QuestionID, dbo.CJQDetail.CJQID, dbo.Questions.SectionID, dbo.Sections.SectionName, dbo.Questions.MinResponse, dbo.Sections.FormID, dbo.Sections.AspPageNum, dbo.Sections.SectionID, dbo.Questions.QuestionID, dbo.CJQDetail.ResponseIDHAVING (dbo.CJQDetail.CJQID = 5) AND (dbo.Sections.FormID = 1) AND (dbo.Sections.SectionID = 13) AND (dbo.CJQDetail.ResponseID >= 76 AND dbo.CJQDetail.ResponseID <= 78)
Help with Stored Proc PLEASE
Posted - 2001-12-12 : 11:58:13
