I created a stored procedure in sql server and it worked when I called from sql QA (exec sp_name)
When I applied this to asp as:
sql = select * from tbl_student
where student_id in (exec dbo.sp_name)
It generated syntax error.
How do I call a stored procedure in asp? Or what is another way to make it work?