Yes you have said that. My question is why? What purpose does continuous values for a primary key provide?

the while...

What is the reason? Are you saying you are using a while...

To add to what Gail already pointed out:

Multiple execution paths.

Repeatedly hitting the same view with nonSARGable predicates (EnumKey != )

Tuning this is far more than an online forum is capable...

And what about concurrency? It is possible you will get duplicate values when more than 1 person is executing this code at the same time. If your goal is to...

sharonsql2013 (6/26/2014)

---

Here it is :

CREATE TABLE #mytable

(

Month_Year Varchar(10),

...

jbalbo (6/26/2014)

---

Thanks for the Help...

Here is my final list(If interested..lol)

Yes the data came from an old foxpro db

Sorry, one more question , OK two....

one...

can I add...

The first suggestion is to remove the while loop that is replacing multiple spaces with one. Jeff Moden has...

sharonsql2013 (6/26/2014)

---

Wont be able to get sample data , but this is how the data looks like

Month_Year MyMonth MyYear Group A ...

sharonsql2013 (6/26/2014)

---

I need to compare the ACC_Backlog data for the last two months. The table has monthwise data from May 2013 until May 2014. I am only looking for last...

You are attempting to delete the entire Keywords table because of this.

DELETE dbo.Keywords

WHERE @nKeyWord_IdArg = @nKeyWord_IdArg

You have the same variable on both side of the predicate. Pretty sure that all...

jbalbo (6/26/2014)

---

Thanks for that..

Now I get ...because it contains a character (0x0003)

I read that only &, < and > (as well as " or ' in attributes) are illegal...

Shakeelr4u (6/26/2014)

---

Sorry for the confusion.

In the sql example that I gave you with the hardcoded programs, STORE2 was the Customer's Program and STORE was the Site's Program.

Please remember that those...

schleep (6/26/2014)

---

??? Maybe I didn't get enough sleep last night, but... I don't believe it should be possible to provide sample data to reproduce this scenario.

To paraphrase my post, "I'm...

That is char(14). Not sure how you managed to get that character in your data but you can just replace it with an empty string.

WITH CTE AS

(

SELECT DISTINCT CLINO

FROM Hill_Comments

WHERE...

If you want this in a single...