hi i want to write clustered index view. the problem is that the query i want to use for the view must be dynamic query. i know all the columns i will get from the query (=from the view), but i must execute it dynamicly because i dont know all of the columns of one of the tables i use for the query. this table is not part of the select clause, therefor i know exactly what will i get in the select clause of the view. how can i create such view? i searched in the net and havent find way to create 'dynamic view' please help me... Thanks, Michal
