Is there any logical limit on the amount of joins you should perform on a query. In my case, there are many lookup tables which i would have to reference...

Try this guy out....not pretty, but might work for you.

CREATE PROCEDURE GetRows

        @Column varchar(25)

AS

       DECLARE @sql Varchar(50)

       SET @sql = 'SELECT ' +...