ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   SQL query removes alias (https://www.excelbanter.com/excel-discussion-misc-queries/70097-sql-query-removes-alias.html)

BusterC

SQL query removes alias
 
Under certain conditions e.g. when grouping data in an SQL query the query
does not return column heading names. Does anyone know if there is a fix for
this problem.

virtualfergy

SQL query removes alias
 
Since misery loves company, I'm in the same boat but not with grouping. If
you use a simple formula to compute the value of a column (e.g. substring), I
get the same behavior. If you hear of an answer, let me know. Thanks.

"BusterC" wrote:

Under certain conditions e.g. when grouping data in an SQL query the query
does not return column heading names. Does anyone know if there is a fix for
this problem.



All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com