If I do the following in SSMS 2008 r2, using T-SQL:
SELECT TOP 1 [col1]
FROM [table1] AS ourResult
The alias column header
ourResult works as expected.
However, if I do the very similar:
FROM [table1] AS min_date1
the alias for the column header does not work and instead there is:
(No column name)
Is there a fix for this somewhat simple situation?