Get a count of headers (fields) in the Select statement of a crosstab query (1 Viewer)

rcovington

New member
Local time
Today, 15:56
Joined
Oct 9, 2014
Messages
4
Is there a way to get a count of the headers (fields) that occur only in the Select statement of a crosstab query? I can get the ordinal position and name of each field in a crosstab query, yet it will be better to get a count of those fields that occur only in the Select statement.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:56
Joined
May 7, 2009
Messages
19,169
You just create a query that counts it:

Selec count(*) from (select distinct columnfield From yourtable)
 

rcovington

New member
Local time
Today, 15:56
Joined
Oct 9, 2014
Messages
4
Thanks for your quick reply arnelgp. I'm more than likely missing something about the element columnfield?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:56
Joined
May 7, 2009
Messages
19,169
If you exam the xtsb in sql there is a portion there, Pivot. That field i am referring.
 

rcovington

New member
Local time
Today, 15:56
Joined
Oct 9, 2014
Messages
4
Thank you again arnelgp. That now gives me a count of the columns (fields) in the pivot clause.
 

Users who are viewing this thread

Top Bottom