By default, SQL Server table names are of the form 'dbo.table_name.' When this gem attempts to alias the unionized result-set, it tries to use the original table name, which SQL Server does not like because there is a '.' in it. I am not able to change my table names. Is there a way to supply my own alias? Or at least remove the 'dbo.' from the alias?
By default, SQL Server table names are of the form 'dbo.table_name.' When this gem attempts to alias the unionized result-set, it tries to use the original table name, which SQL Server does not like because there is a '.' in it. I am not able to change my table names. Is there a way to supply my own alias? Or at least remove the 'dbo.' from the alias?