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?