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

Can any one could solve this problem, if yes plz help me to solve it.

Answer 2

hai Sanjay Kumar,

Thanks for your valuable reply, Actually what iam trying to implement is to make a repeater user control that can generate dynamic columns , that is if i use that repeater in a web form with 3 columns  i must be able to use that repeater control in the next web form for more than or less than 3 columns , so the problem is i need to bind that data with out using source code, that is "Eval" method can only add one data from a particular table only, i need to generalize that part and need to made that part data binding in general, so can i bind data to a repeater without source code by using only code behind.

Please pardon me if there is any confusions, ask me for more clarifications to my idea.

Answer 3

Hi

try this

http://www.c-sharpcorner.com/UploadFile/47548d/twitter-bootstrap-and-repeater-control-in-Asp-Net/