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?

That'd be a good plan.... make 'em do the work for you... then show 'em why it wasn't a good idea to start with... then they would stop ignoring your...

k.. then you're on your way... Good luck with this project.

Well why r they asking you to merge the tables??

Are they asking you to take an apple and an orange table to make a fruits table. Or to take...