I'm thinking the derived column is not as effecient.

If I create a stored procedure, I still have to pass the parameter. And that's the whole point of what I'm trying to do here - figure out how to get parmeters working.

I'm getting the following error message, if that helps:

Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command from variable" access mode, in which the entire SQL command is stored in a variable.

I'm trying the following SQL for the "SQL Command":

SELECT

CONVERT(DATETIME, ?) AS dtMonthEndDate, Field1, Field2, Field3

FROM dbo.MyTable1