in query builder select all columns with *

[Jaheuk]

dear all,

I am doing a proc transpose. the number of columns is based on the data.

If I put a query afterwards I would fetch all transposed columns:   select *.T1 from . . . .

HOW do I do this with query builder ??

Kr,

Herman

[RW9]

You are facing the (well one of the several) reason why not to transpose data.  SQL is built to work with few columns (i.e. small structure, lots of records), in fact SAS also works that way with by groups, although its a lot more flexible.  So unless you want that data that way for a report and no furter processing, then just don't transpose it.  It is far simpler to code with a normalised data structure, than to mess around trying to work out what columns are present etc.

[CaseySmith · Accepted solution]

EG's point-and-click Query Builder does not currently support generating "SELECT *" syntax.  It currently explicitly lists each column that you select in the Query Builder GUI.  So, you can select all the columns in the Query Builder GUI, but the generated SELECT statement will look like "SELECT col1, col2, ..., coln", rather than "SELECT *".

Adding explicit support for "SELECT *" to the Query Builder is on our roadmap.  It is a reasonable thing to want to do.

Thanks for the feedback.

Casey

[PhilC]

Casey,
why doesn't query builder support "select * "? Is there a reason? I want to request the incorporation of this but is there an obvious reason known amongst experts why it isn't that way?