Question is Regarding CTE (Common Table Expresssion)

Question

 I found that CTE Common Table Expresssion (SQL Server) can only be used immidate follow by select statement. if we can't use CTE with any other select statement then what is the use of the CTE. Because we have another option to achieve this temperoary table concept.

Answer 1

There's a couple of ways you can do it. You can create a panel containing all the controls you want for the advanced mode, and set it to be not visible by default. Now the button you press can alter the visibility of that panel. If you place all of the controls in a Panel called panel1, add this line to your button click event: this.panel1.Visible = !this.panel1.Visible; Add anything else to modify the text of the button if you wish. Another way to do it might be to create two different forms, but have one be the advanced, and the other the basic. There might be a good way to do that using inheritance, but having never done that myself, I can't give you too much input on it.

Answer 2

Sorry I don't understand the question??? Could you explain some more?