In VFP, I can use a variable/parameter in an SQL 'FROM' and clause, e.g.

local AliasName, OutputName 

AliasName = 'MyInputTable'
OutputName = 'MyOutputCursor'

select IT.* into cursor (OutputName) from (MyInputTable) IT order by IT.RefId

Can I do something similar in SQLServer stored procedures? How?

Thanks in advance