SELECT scx.strEmail 
FROM   synvStudents as ss
INNER JOIN tblStudentXContact  as scx ON ss.strNBEN  = scx.strNBEN
WHERE  ss.bitActive = 1 AND 
ss.strSchoolCd = @strSchoolCd AND 
scx.strEmail <> ''

quote:

---

Originally posted by vijayisonly

Chk this. Have a look at both the solutions provided.
http://www.sqlteam.com/article/introduction-to-dynamic-sql-part-2

---

DECLARE
		@SQL VarChar(1000),
		@intError INT,
		@strErrorMessage VARCHAR(200),
		@intRowCount INT;
	
			   
		Select @SQL = 'SELECT scx.strEmail FROM   synvStudents as ss INNER JOIN tblStudentXContact  as scx ON ss.strNBEN  = scx.strNBEN '
		Select @SQL = @SQL + 'WHERE ss.bitActive = 1 AND scx.strEmail <> '''' AND ss.strSchoolCd = ' + @strSchoolCd + ' AND ss.strGradeLevel in (' + @strGradeLevel +')'

		Exec ( @SQL)

quote:

---

Originally posted by lucsky8

Hi i will try to explain my problem the best i can.
I have an aspx page that call a SP in sql server
The aspx have dynamic checkbox. The number of checkbox can vary.

Here the query i have now :
Ex :
@strSchoolCd = the checkbox from the aspx
@strSchoolCd = '1,5,6,8'
I need to create a select statement where strSchoolCd = 1 or strSchoolCd = 5 etc.. depeding on the numer of checkbox

Any idea how to do it?
I know i probably have to create a temp table and use some sort of split function but i have no idea how to do that

SELECT scx.strEmail 
FROM   synvStudents as ss
INNER JOIN tblStudentXContact  as scx ON ss.strNBEN  = scx.strNBEN
WHERE  ss.bitActive = 1 AND 
ss.strSchoolCd = @strSchoolCd AND 
scx.strEmail <> ''

Tks

---