I have to write an extract in SQL Server accessing a teradata database. I'm running into problems with fields that have been defined with a column title.
If I select * from table - the select fales because it's trying to select 'column title' from table rather than select column_name from table.
So I changed my query to select column_name from table & receive an error message Invalid column name 'column_name'.
Both sql statement work in Teradata SQL Assistant - just not in SQL server.
Any ideas what the problem could be? This is the 2nd time I have worked with teradata.