TSQL = query

I think this is a much easier question

and i have seen this done by other programmers, but i have forgotten how to do it.

Can someone teach me how to create a stored procedure, with parameters which would look like this.

CREATE PROCEDURE dbo.TestProc
(
@selectstatement varchar(50) = NULL,
@whereclause varchar(50) = NULL,
@orderby varchar(50) = NULL
)

AS

tsql = '@selectstatement + @whereclause + @orderby'

is this even possible?

thanks for any ideas

Yes you can do something like



I'm not sure it is very good idea, but you can

could you please give me some more code... how could i pass the select statement to the said parameters?

you can call your store procedure like

thanks men!