Can any one please tell me how to create Index on this view
View Complete Post
i faced one problem when worked with Inline views.
For some reasons, i used Inline views in our project. Is there any possiblity to create Index on InlineViews. I will expain more clearly using my code.
select (Row_Number() over (order by Net)), * from (select ID,Fname,LName,Sal, Sal + 1000 as Net from EMP) cc where Net between 10000 and 20000
Here, ID,Fname,Lname,sal are the table columns and Net is the newly cretaed column in Inline view. I know how to create Index on table columns but i am getting struck how to create Index on Inline View columns means here i need to create index on Net column.
Thanks in Advance.....
I need to create the index for a column and accessing that in sqlserver 2005. Please any one help me.
I have a fairly complex SharePoint Designer 2007
Data View they have added two more requirements.
1. Have the columns on the right side be able to scroll left to right as there is a large number of columns, while the first 3 columns on the left side stay locked in place. This is only one list not two, and because of some other requirements
I have it must remain to be just one list.
2. Then they also need to have scrolling up and down of the entire list with the headers locked in place.
The first requirement is more important than the second, but preferrably I need to do both.
I am new to XSL so not familar with the syntax. Is this something I can do on a custom Data View? Does anyone have any examples of how?
I have a drawing that show how it needs to look but I don't see an option here to upload a graphic.
So here is a link to my graphic example uploaded to my blog area: http://lindachapman.blogspot.com/ or just the image here: http://4.bp.blogspot.com/_aB01ue__NvQ/TGL42MOvrGI/AAAAAAAAAA4/c3xP4uCy4BU/s1600/Scrolling.png
I failed to mention that 3/4 of the columns are HTML Calculated fields wh