From Books Online:

The ORDER BY clause is not valid in views, inline functions, derived tables, and subqueries, unless either the TOP or OFFSET and FETCH clauses are also specified. When...

adonetok (8/3/2015)

---

I used code below, it works but I am not sure it is good.

select distinct ORDERID from (select top 100 percent ORDERID,ORDERDate from ORDER where ORDERID = '123456' order...

ben.brugman (8/3/2015)

---

Enforcing constriants often prevents actions. Most of the time it prevents 'illegal' actions. But sometimes it prevents actions, which are functional.

In general I am in favor to enforce constraints...

sgmunson (8/3/2015)

---

ben.brugman (8/3/2015)

---

This weekend I have been away from the keyboard. And as often the best idea's occure when away from the keyboard. E.g. on my bike (pushbike) or under...

Ed Wagner (8/3/2015)

---

I couldn't tell you, Koen. I'm back after a...

Jeff Moden (8/2/2015)

---

Alvin Ramard (8/1/2015)

---

Jeff Moden (7/31/2015)

---

You did fine and you're absolutely spot on. You've said...

Eirikur Eiriksson (8/2/2015)

---

Piling on Luis's and Gail's posts, withholding or piecemeal'ing any relevant information is a waste of everybody's time! From the limited information supplied so far, one question arises,...

Just a couple of clarifications.

To change the code into a stored procedure, you just change the variables declaration to become your SP header.

The query does not use the column list...

No, you didn't. You attached an image of the execution plan which isn't the same thing...

I feel like I should apologize for Alvin as his answer might seem rude. But he makes a very good point.

There's a lot of documentation on the changes from what...

That doesn't help a lot. You should post DDL for the tables, views and indexes involved and actual execution plan (right click on the execution plan and Save As...).

The index...

The Dixie Flatline (7/31/2015)

---

Alvin Ramard (7/31/2015)

---

Luis Cazares (7/31/2015)

---

That wasn't the only attempt on that day. Here's a completely lost Oracle user.

But hey,...

Your sample data doesn't help much to test and validate. I had to make several corrections which mean that you didn't test your sample data.

This might be an option, but...

Naveen PK (7/31/2015)

---

Luis Cazares (7/31/2015)

---

I'm just wondering why would you need to update these columns as you shouldn't store values this way if you want a normalized table. And if...

I agree, the table name is not enough information to eliminate duplicates, the columns defining the key are necessary.

A lot of things can make a row unique even if it's...