I've got a similar problem with scheduled reports. Did you find a solution at all?

On the ISNULL() point I would agree and actually recommend using COALESCE() as its more standards compliant. But the actual point of the query is to sort by [dbo].[Foo].[Description] and...

The point is that I want the column named "Description".

I have managed to deploy it using the provided installer by simply modifying the INI file with my specific database reqirements. One hassle I found was that the INI file...

The problem in my mind is not that I am using the IN operator, but rather the MONTH() or DATEPART() functions. It seems that functions are not eligible in this...

Here is an example I quickly threw together to illustrate the problem:

CREATE TABLE dbo.data_q1(

    [date]    DATETIMENOT NULL CHECK (MONTH([date]) IN...

Thanks racosta & Andy for your feedback.

Now I am considering the possiblity of using both approaches. Firstly, my logic is already in a stored procedure. Does anything prevent me creating...

For what reasons? Please justify your opinion with at least some form of logic. 🙂

quote:

---

I'm a rank novice, so the problem I have is that after I've created views in SQL 2000, sometimes Enterprise Manager will...

I recommend that you update your BOL to the latest available. I too recall seeing that Indexed Views were only an Enterprise/Developer feature, but the latest BOL (as quoted above)...