Hello ...... (Always post your real Name in this newsgroup !)
Try using dynamic SQL
---
Create Procedure Test Viewname varchar(50)
AS
DECLARE SQLSTatement Nvarchar(50)
Set SQLStatement = 'Select * from ' + Viewname
Exec SP_ExecuteSQL SQLStatement
---
HTH, Jens Süßmeyer.
Bookmarks