Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 17th, 2008, 07:03 AM
Registered User
Join Date: Jan 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to RehanHussain
Default Cannot index the view '. It contains one or more d

SELECT dbo.WEA_WeavingDetail.sysWeavingDetailNo, dbo.WEA_WeavingDetail.DyeSet_Code, dbo.WEA_OrderIntimationDetail.Dyeing_Code,
                      dbo.WEA_WeavingDetail.Fabric_Code, dbo.WEA_OrderIntimationDetail.Weaving_Code, dbo.WEA_WeavingDetail.Lot_No,
                      dbo.WEA_WeavingDetail.Beam_No, dbo.WEA_WeavingDetail.Loom_No, dbo.WEA_WeavingDetail.Warp_Length,
                      SUM(dbo.WEA_DoffDetail.Fabric_Length) AS Fabric_Length, COUNT_BIG (*) AS CNT
FROM dbo.WEA_WeavingMaster INNER JOIN
                      dbo.WEA_WeavingDetail ON dbo.WEA_WeavingMaster.sysWeavingMasterNo = dbo.WEA_WeavingDetail.sysWeavingMasterNo INNER JOIN
                      dbo.WEA_OrderIntimationDetail ON
                      dbo.WEA_WeavingDetail.sysOrderIntimationNo = dbo.WEA_OrderIntimationDetail.sysOrderIntimationNo INNER JOIN
                      dbo.WEA_DoffDetail ON dbo.WEA_WeavingDetail.sysWeavingDetailNo = dbo.WEA_DoffDetail.sysWeavingDetailNo
GROUP BY dbo.WEA_WeavingDetail.sysWeavingDetailNo, dbo.WEA_WeavingDetail.sysOrderIntimationNo, dbo.WEA_WeavingDetail.DyeSet_Code,
                      dbo.WEA_WeavingDetail.Fabric_Code, dbo.WEA_WeavingDetail.Lot_No, dbo.WEA_WeavingDetail.Beam_No, dbo.WEA_WeavingDetail.Loom_No,
                      dbo.WEA_WeavingDetail.Warp_Length, dbo.WEA_OrderIntimationDetail.Weaving_Code, dbo.WEA_OrderIntimationDetail.Dyeing_Code

Old April 11th, 2008, 11:38 PM
Friend of Wrox
Join Date: Aug 2004
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts

And the question is?

Old April 12th, 2008, 03:57 PM
Friend of Wrox
Join Date: May 2006
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts

You can't index views that includes aggregate functions.
It is there, black on white, in Books Online.
And the complete error message says it too...

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating Index on View - SQL prince500 SQL Server 2005 5 September 7th, 2011 07:35 AM
Urgent - Send mail with plain view and html view ashish.dadhwal ASP.NET 2.0 Professional 0 November 27th, 2008 01:49 AM
populate details view or list view non empty rows iinfoque ASP.NET 2.0 Basics 0 March 11th, 2007 06:11 AM
Index View Asish SQL Server 2000 1 November 7th, 2003 01:12 PM
View dynamic content with MS Index Server? shogunmike Classic ASP Basics 0 June 26th, 2003 12:39 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.