Home T-SQL min function with alias for column header
 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: SELECT MIN([Date]) 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?