Absolutely.  I appologize if I wasn't too clear.  You can install SSAS without the SQL Server isntall.  They just come in the same installer package.

From your post I get the idea that you want to query the whole database (i.e. each table in the database).  If this is the case, you can use the...

SSAS is a part of the SQL Server install.  It will be an option to install during the SQL Server install process.

One more confirmation.  Drop the plan and recreate it.  It sucks, but it works

Pro SQL Server 2005 Reporting Services

This is by far the best book on RS I have come across.  If the link is not working for you, just go to amazon.com...

I am dying to hear the answer to why they do not want to use an ORDER BY clause

A little more information on the environment would be useful, but from what you have posted I have a suggestion.

I made a batch file that opens notepad.exe and passes a...

At least show the courtesy of not hiding advertising as legitimate articles.

Just as a friendly reminder, you can also use the sp_helpdb stored procedure to see this data as well, plus a little more.

>>> Hi,

>>>    can somebody tell me how can i write a stored procedure which returns output variables as below

>>> @year2

>>> @year1

>>> @year1

Are two of the return variables the same...

Assuming that the inv_value and cme_value might not be numerical, you could also do it this way.  This is also assuming that the item column is distinct for each item...

The graphic in this article is atrocious.  I cannot read half of the captions and the image is terribly grainy.

I really thought you were going to stop that sentence at read

Seriously?  This is a 5 second search in BOL to get the answer to your question.  I am not trying to be mean, but do you even search BOL or...

I do the same this when programming.  I will include the 1=1 in my where clause so that any other conditions can be included as ", blah=blah".