I'm using SQL Server 2008 R2 and was wondering if there is another way of writing something like EXEC dbo.myProcedure (SELECT columnName FROM TableName) or EXEC dbo.myProcedure @myStringVariable + 'other text' so that these procedure calls actually work , without putting the whole stuff into a variable first.

SQL Server : procedure call, inline concatenation impossible?

I'm using SQL Server 2008 R2 and was wondering if there is another way of writing something like

EXEC dbo.myProcedure (SELECT columnName FROM TableName)

EXEC dbo.myProcedure @myStringVariable + 'other text'

so that these procedure calls actually work, without putting the whole stuff into a variable first.