Sure, you can pass the SQL statement in as a varchar

CREATE PROCEDURE my_sp
@tcSQL varchar(5000) = ''
AS
EXECUTE (tcSQL)