Although it is certainly possible for a procedure to block another instance...

Atif: Why 3 layers? I don't think that you need the middle layer, "TOP 90 percent" doesn't do anything for you and the "Order By .. ASC" can be...

tfifield (7/22/2008)

---

I'm afraid the multiple profiles will be difficult for my client to maintain. They seem to have people come and go and they want the the Reply...

Well, I already knew some of that and as for the rest, it wouldn't have changed my response at all.

Alex Rosa (7/26/2008)

---

So, I need to lie. Decreasing my last salary.

So, if I knew how to negotiate a good salary before and now I can decrease my salary because I...

Much easier:

Select * From INFORMATION_SCHEMA.COLUMNS

Oh yeah, you don't have HT (hyperthreading) turned on do you?

Gerard ONeill (7/25/2008)

---

2) If so, can you think of *anything* I can do inside (that works when only 1 instance of this proc executes) that would fail when 2 of...

Please provide examples of your code for those cases where the CMD.EXE's are hanging around.

Select Country, State, City From Cities

Glad I could help.

If you need the reversed rows back in thier original column order, that is slightly more complex (which I will leave as a problem for the reader). 🙂

This should do it:

Select PointA, PointB

From @Routes

Where PointA <= PointB

UNION

Select PointB, PointA

From @Routes

Where PointA > PointB

Well, 1.7861E+32 is slighty less than 2*10^32, which is approximately 2^108, which is way more than 2^63-1, the highest positive number that Bigint can represent. If you want numbers...

Muhammad Furqan (7/25/2008)

---

can you please tell me how can we use this stored procedure in some view? I don't think that i need to post my complete database schema here,...