.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Unable to create index for view

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
Hi, I'm including the script for my ProductCategories table but I think it might be very beneficial for you to understand what I'm doing first: As the name implies, the ProducttCategories table is where I store all product categories for an ecommerce site. Furthermore, the CategoryHierarchy column uses the HierarchyID datatype in SQL Server 2008 so that I can have a hierarchy and make suggestions to users who are looking for a product in a category along with all its child categories. Also, in order to make the site as user friendly as possible, I've implemented friendly URLs. Therefore, I need to do a reverse look up when someone requests: Electronics-DigitalCameras-DigitalSLRs to figure out the CategoryID (int) for the Digital SLR's category. I wanted to create an index in the database to make sure these look ups would have pretty good performance and that's where I got stuck. First, I got a message that told me that I couldn't create an index because my view was not bound to schema. And when I tried to do that, I got another error saying "Cannot schema bind view 'dbo.vwProductCategoriesAndPathsOrdered2' because name 'ProductCategories' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself." The view simply creates a category path that looks like this: Electronics > Digital Cameras > Digital SLRs I'd

View Complete Post

More Related Resource Links

cannot create an index on a view

Hi All, Can I create an index on the following view? Create view myview with schemabidning as select id, date, value from tablea a right join (select id,min (date) as mindate, value from tablea ) b on a.id = b.id and a.date = b.mindate GO CREATE UNIQUE CLUSTERED INDEX IDX_1 ON MYVIEW(ID)     Right now i am getting an error.   Cannot create index on view "myview" because it references derived table "B" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view. shamen

How to create Index on Inline View columns



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.....

create index on view


HI Guys

Can any one please tell me how to create Index on this view

Create VIEW [dbo].[Vw_Fact_GLTransactions]








how to create index for a column


Hi Friends,

                       I need to create the index for a column and accessing that in sqlserver 2005. Please any one help me.


How to create scrolling table for columns in a SharePoint Designer Data View


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

create a dynamic view on code

How i can create a new view on code (on runtime) if this view dont exits?   Thanks

Create view

I need to create aview like this. Field1        Field2 James         Here it will be a SELECT from various tables where name='James' Helen          Here it will ............................................    where name='Helen' How to create this view.  Field1 is also from some table. NSG12

How to create a view in my database from a table in another server/database

Is there a way to create a view in my database referencing a table in another server/database if I have the connection information.  I know how to do it in Oracle, simply create a database link, but have never done so in sqlserver.

unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

Unable to Create a New SSP

HI Team,      I was creating a New SSP, its taking a long time so i stopped the SSP in creation by clicking the browser back button. Now i am  not able to create the new SSPs and unable to delte the SSP  I stopped in the middle It says "provisioning in progress" I am not able to delete the ssp which I stopped in the middle while creation We are using Share point 2007 I am new to share point Please advise how to fix this issue Thanks Kumar

how to create jquery tree view

A Simple Query Pass to connection String 1 My Query is SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.COFROM V_HIERARCHY1 a2,My Data isHD    HEAD    SH    SUBHEAD    TRK    TRACK    TGT    TARGET    PDC    DT_RELEASE    STATUS    COHR    HR    Rec    Records    Leave    Leave Records    HRL.0002    Quarterly Review    01.07.2010    04.07.2010    Planned    EdlinkHR    HR1    DB    Database    SAL    Salary    DDS.0001    Calculation of Monthly salary    08.08.2010    09.08.2010    WIP    EdlinkHR    HR    Rec    Records    Ind    Induction Records    HRI.0001    Completion of dossiers.    08.07.2010    10.07.2010    WIP    EdlinkHR    HR    DB &

Unable to create Web Folders in Windows Server 2008 R2

Hi, We are unable to create web folder from a Windows Server 2008 R2 system as we do in Windows XP. The web url cannot be identified. The web url is an oracle repository application built in 32-bit OS and now we need this to be added in Windows Server 2008 R2 machine. Kindly help.  

Unable to Create a New SSP

HI Team,      I was creating a New SSP, its taking a long time so i stopped the SSP in creation by clicking the browser back button. Now i am  not able to create the new SSPs and unable to delte the SSP  I stopped in the middle It says "provisioning in progress" I am not able to delete the ssp which I stopped in the middle while creation We are using Share point 2007 I am new to share point Please advise how to fix this issue Thanks Kumar

Unable to create columns in document library after applying custom master page to site

Hi, I have applied a custom master page to a site.There is a document library in it. I am unable to add columns in it or change the default view.Nothing happens when I click on OK butoon after making my changes. However the columns are created/default view is changed when I apply the default master page. Guess I am missing some TagPrefix or sharepoint control on master page.I had solved this problem earlier in this way but don't remeber it now. Can anyone help?

Create a new list View Style

Hi, In SharePoint 2010 for XSLT List View Web Part you can assign different view styles using SharePoint Designer. For example "Basic Table", "Boxed" or "Shaded" etc. These styles just don't fit my needs. So my question is how can I create my own View Style which I can apply to any list? I came across "Customize XSLT > Customize Entire View" option under Design tab in SharePoint Designer which allows me to change the XSL stylesheet and control the rendering for a list. But how can I create my own list "View Style" which I would like to reuse with other lists too? Thanks, Hitesh  

Unable to create a new subscription

Hi, I'm trying to re-create a new subcription on my server. When I tried to connect to the the publisher server, i kept getting an error message saying " SQL server could not retrieve the list of publication for "D..." Additional information: An exception occured while executing a transcat- SQL statement or batch. [Microsoft.sqlserver.connectionInfo} A transport level error has occured when receiving results from the server. [Provide: TCP provide error:0 ] - The specified network name is no longer available] [Microsoft sql server, error 64) I can ping the publisher server and also connect from my subcriber server using remote desktop.  I tried connecting to the publisher server using the sa account. Is this a permission issue? Thank you.

How to create SQL-login with permissions for view-only SQL-Agent-Jobs?

Could you please help me with resolving next problem: How to create SQL-login with permissions for view -only SQL-Agent-Jobs (he cannot create, modify or delete)? I am using MS-SQL-Server version: 8.00.194 In other words : how to create in version 2000 (8.00.194) the same as 'SQLAgentReaderRole ' in version 2005 (for more details see http://technet.microsoft.com/en-us/library/ms188283.aspx).
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend