Stored procedure problem....

[Nagraj Naik]

Hi all, I am creating query at runtime this query is depend upon dynamic criteria selection. Now when this query is created I want to send this as stored procedure query part in sql stored procedure i.e. select * from records where recno>100 // this is sql query I want to set this query as stored procedure query //stored procedure create procedure recordcount as //above generated query shoul be here return I hope you understand my problem. If Know solution share with me...... Let's Teach Life To Laugh........:laugh:

[albCode]

CREATE PROCEDURE recordcount @recno int(4) AS SELECT * from records where recno > 100

[Nagraj Naik]

Hi, You don't get me. Basically I want to send my dynamic query as query to stored procedure.I mean stored procedure is not created i want to create it dynamically with my dynamic query

[Faisal Khatri]

Please specify your problem clearly

[surshbabuk]

hi try it bteeeeeeeeeeeee create procedure getrecno @recno as begin select * from tablename recno>=100 end;P suresh babu.k -- modified at 10:33 Tuesday 20th June, 2006