I believe that the EXTRACT function is MDX language, that would work against a cube. Are you doing this against a SQL Server cube, or against the table?

Thanks to those of you who replied.

I think you have a many to many relationship. Do your sales people have more than 1 customer? Or would they really only have 1 customer. If it's...

I'm not sure I understand. You're saying in order to partition on Period you have to include it in the primary key? Why do you think that? ...

Danster (4/30/2007)

---

As one of my first forays, I thought I'd whip up a typical view. No

problems, but when I execute, the results pane say 'cell is read only'.

I'm used...

dgarcia182 (7/24/2008)

---

So I create a SELECT query spanning a dozen tables showing the data that is causing an issue.

I notice one of the rows has errant data noticing that one...

I have no idea what this means.

Your variable @qry as nvarchar(3000) is too small to hold your create table statement.

Do you really need it to be a nvarchar? Your create table statment is...