I haven't tried anything like this, but if there aren't many possible values for @mycolumnname, couldn't you use a CASE? Something like:

SELECT CASE @mycolumnname

...

If you only need to pass "records" with one "field", you can pass a comma-delimited (or other delimited) string as a parameter and call a StringToTable function to translate the...