Here is the code provided by Luis and my shot at it as well:

create table #testdata(

ID int,

Source varchar(10),

RankVal...

Would be nice if we could hear more from the OP. It seems like he just disappeared.

Grant Fritchey (4/28/2014)

---

Lynn Pettis (4/27/2014)

---

Well, I put in for another 6 months out here in Afghanistan. Looks like I'll miss another PASS Conference. I did put in for...

Eirikur Eiriksson (4/27/2014)

---

Jeff Moden (4/27/2014)

---

Eirikur Eiriksson (4/8/2014)

---

hisakimatama (4/8/2014)

---

Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck...

Well, I put in for another 6 months out here in Afghanistan. Looks like I'll miss another PASS Conference. I did put in for 2 weeks over Christmas...

Could you please explain why you are so adamant about replacing the view in the code of the stored procedure? I really don't see any advantage to doing so...

Before you start looking at partitioning you may want to look at the code that is forcing the table locks and the current indexing (clustered/nonclustered) on the table.

karend211 34657 (4/25/2014)

---

Thanks for the reply John, but question....

I understand what you are saying about the consistancy issue being possible... but say I had a corrupt master occur...

I guess we need more information as your...

It would help if you would post the DDL (CREATE TABLE statement) for the table(s) involved in your query, some sample data for the table(s) (as INSERT INTO statements), expected...

Do you have access to any backups for the database? You may need to see if you have a good backup prior to the database becoming corrupt.

Please do not cross post on multiple forums, it tends to fragment answers.

Please post any responses here.

If you look carefully in the code you actually will find the join criteria in the original code.

I have reformatted the code and moved things around a bit:

SELECT DISTINCT custyear

FROM

...

DNS Redirection is one way to go.

Users use the PRDB.+ and DNS actually routes it to the correct VM PR01. or PR02, etc.

Pretty sure I can make the...