Please do NOT cross-post.  WE monitor all the boards all the time.

Please continue the discussion on this board : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=324&messageid=384251

A foreign key constraint cannot be applied if the Parent table does NOT have a unique constraint of any kind.  By removing the PK, you violate that rule.

Try this :...

Archive the inactive rows somewhere else.  Add a check constraint that Active must equal 1 and run that new constraint with check.

Also you can post the exec plan of that...

.  Thos error message are misleading sometimes .

You already have the right syntax for it.

The view will still have to scan the table.  Indexed view may be an option.  But this actually creates a second table.  I think I'd go with with separating the...

Hmm, what are you getting exactly, and what are you expecting to get?

I'm always curious for these things... which one is the fastest??

You got me on my curious side Sergiy, what is that other route you are talking about?

Since when is there a bad way to do something that works in sql server???

Granted that profiler seems like the best choice here .

This seems like an Orders / OrdersDetails schema.

Based on that assumption you need to do something like this :

SELECT O.ID, ISNULL(Dtd.SPrice, 0) AS SPrice FROM dbo.Orders O LEFT OUTER...

Let me put it this way.  I've seen this done before using sql server.  But the guy pretty much wrote a lite version of Excel.  So I'd try to find...

I'm not laughing at anyone... except at one comment Jeff made a few days (or weeks) ago.

Who needs that crap... wasn't it you that proposed a fully xmled Entity-value system?  No need for all those table things anymore .

Can we see the rest of the table's definition?