CREATE PROCEDURE sp_create_view
AS
execute ('create view test_view as select * from Table1')

Или так

CREATE PROCEDURE sp_create_view
AS
declare @sql nchar(1000)
set @sql = 'create view test_view as select * from tblMembers'
exec sp_executesql @sql