Get a sneak peek—Download Microsoft Office 2010 Beta today

Take your projects to a higher level with Microsoft Office 2010 Discover how you can bring your ideas to life with Microsoft Office 2010 With the Microsoft Office 2010 Beta, you can try out all the new features that will help take your projects to a higher level — long before the new version of Office is available for purchase. Express your ideas, connect with others, and create amazing results virtually anywhere life takes you with Office 2010. • Turn ideas into powerful presentations. In addition to the enhanced image-editing tools, now you can edit video files right in Microsoft PowerPoint 2010. And with Broadcast Slide Show, you can deliver your presentations in real time to virtually anyone with an Internet connection.1 • Manage email easily. Gain control over your email with Microsoft Outlook 2010. The new Conversation view lets you consolidate the discussions you're interested in, ignore the ones you're not, and get more things done faster. • Organize your thoughts. Keep track of your best ideas with Microsoft OneNote 2010. It gives you one convenient place to collect any thoughts, images, videos, or Web links for a project — and then find them with a simple search tool. • Work however and whenever you want. Microsoft Office Backstage view has a quick way to store documents online and access them from virtually anywhere. And Microsoft Office Web Applications make it easy to work on group projects together, whether you're miles apart or just down the hall.2 Experience how Office 2010 adds impact, energy, and efficiency to every project. Download the Office 2010 Beta today. 1 An appropriate device, Internet connection, supported browser (Internet Explorer 7 or later, Firefox 3.56 or later, or Safari 4 or later), and Windows Live ID are required. 2 Microsoft Office Web Apps are currently only available to individuals using the Office 2010 Beta. Please note that only select Office Web Apps support online editing at this time. Discover new ways to share your ideas with Microsoft Office 2010. Watch the new features video   Visit the Microsoft Office Beta Web Site | Unsubscribe © 2010 Microsoft Corporation. Terms of Use | Trademarks | Privacy Statement

---

http://windows.microsoft.com/shop Find the right PC for you.

Indexed View Error - select list does not include a proper use of COUNT_BIG

Problem:

I Tried to Create a Index on the Existing View, then i got the following Error:

Msg 10138, Level 16, State 1, Line 1
Cannot create index on view 'EISA.dbo.VIEW_CLIENT_GLOBAL' because its select list does not include a proper use of COUNT_BIG. Consider adding COUNT_BIG(*) to select list.

Code1:

I Created View By using following Query:

Code2:

I Used the Following Query to Create an Index on the Created View "VIEW_CLIENT_GLOBAL" By using following Query:

Solution:

If you want to create a Index on the view, we need follow the rules given in the following link,

http://technet.microsoft.com/en-us/library/ms191432.aspx

If GROUP BY is specified, the view select list must contain a COUNT_BIG(*) expression, and the view definition cannot specify HAVING, CUBE, or ROLLUP.

I Altered My View with COUNT_BIG(*) AS COUNT as shown below:

Then i created the index on the view by Query which is available in "Code2" Section, it works fine.