Check the inserted lines... Once on the server they are all kept as '' (no space). Looks like the where condition is treated the same way (rtrimed). ...

How about something like this :

Select CustomerID, Year, Count(*)

from dbo.HistoryTable

group by CustomerID, Year

having count(*) < 12 or (Year = year(getdate()) and COUNT(*) < Month(Getdate()))

This returns only the...

I've once worked on a similar problem. I had to export the billing information to a text file so it could be imported to a 3rd party software.. Easy...

I would suggest you buy a book that explains how sql server's optimizer works under the hood... maybe inside sql can help you. But Frank would be better at...

HTH.

Did you run my script???????

Run this and find for yourself :

CREATE TABLE [dbo].[TypesCommentairesADPS] (

[PkTypeCommentaireADP] [int] IDENTITY (1, 1) NOT NULL ,

[DescTypeCommentaireADP] [varchar] (50) COLLATE French_CI_AS NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[TypesCommentairesADPS] WITH...

From SQL Team

There are several requirements that you must take into consideration when using Indexed views.

1. View definition must always return the same results from the...

Care to elaborate on those reasons Frank?? Can't think of many right now.

Not always stupid.. I've heard of cases where a view using a view was slower than a single select statement, but unless you've proven that fact you probably wasted some...

You can't declare a variable in a view.. this will do the trick :

SELECT RTrim(op_o.team) AS [Team],

op_o.last_rep AS [Consultant],

RTrim(op_o.type) AS [Opportunity Type],

Convert(Char, op_o.open_date, 101) AS [Opportuntiy Create Date],

RTrim(op_o.curr_mile) AS...

What uniquely identifies the rows??

Because you can add many more things than days (from books online)

Syntaxe

DATEADD ( datepart , number, date )

Year : aa, aaaa

quarter : qq, q

Month : mm,...

You're better off learning this method :

Select dateadd(d, -90, Getdate())

Can you post the query and the ddl so we can show you how to do it?