Team - I am coding a page in classic asp and SQL. I have a query from sql which fetch few data. I know how to display those in Classic asp.
However what i dont know is, lets say, the output of sql gives me something like this,
Customer, Root Cause, Score
Here, for every 1 customer, i will get 5 rows (each differentiated by Root Cause). Client wants me to show only 1 Root Cause & have a plus button in customer. If the end user clicks the +, it should display the other 4.
Any sample query on dynamic table wouldbe greatlyappreciated.