I have 10 columns on a GUI interface the user can group by or sum by any of these 10 columns.
There are two listboxes one for group by and one for sum by.
The user can choose the columns to group by and also the columns to sum by.
I need to write a dynamic sql query to fetch the data based on the columns selected for grouping and sum.
Any examples would be great