Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Only return set # of columns

Status
Not open for further replies.
May 9, 2007
11
US
I have a query that will has a rank, and that rank can be filtered. This sql returns data in a matrix.
1 2 3 4
1 X Y Z 0
2 Y Z 0
3 Z 0
4 0
When i set it to filter based on rank < 4, then it will not show the fourth row, but it will show the 4th column (which will be all zero's).

Does anyone know how to dynamically hide columns, or only show a certain number of columns?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top