Lynn Pettis (8/22/2014)

---

Sean Lange (8/22/2014)

---

brad.mason5 (8/22/2014)

---

Not sure if this is what you are looking for. This is assuming OrderID is the correct order you want.

SELECT TaskID

...

If a row gets deleted, or added, I will re-order. Thank you for your answer.

Luis Cazares (5/29/2014)

---

That seems as a good approach. I'll leave 2 alternatives which might not be better.

WITH VLeaders AS(

SELECT l.LeaderID,

...

Reply to sgmunson - thanks for your reply.

I have to admit I have never got into query plans before ... I pressed Ctrl M before running your code and mine...

But, isn't that not a 'catch-all query'? It hasn't got any ... WHERE (ProjectID = @ProjectID or ProjectID = 0) AND (ContractType = @ContractType or @ContractType = '') ... etc.

It...

I have done that sort of thing before. I might have had, say, 6 various sort conditions to satisfy and I have written as you suggested. So, effectively you write...

Thank you for that.

Ed Wagner (2/10/2014)

---

sku370870 (2/10/2014)

---

ChrisM@Work (2/10/2014)

---

The return value of a stored procedure is int, and cannot be changed. Traditionally it was used to indicate success (RETURN 0) or failure (RETURN n,...

Sorry, that '@ReturnValue' error was a typo. Caused by the fact that I have probably typed the line

Set @ReturnValue = -999

tens of thousands of times!

So, what...

Thank you for your reply.

Thank you for your reply.

May I ask what is, no doubt, a stupid question. When you say it is the 'version of the instance' ... what does that mean?

If I...

Thank you.

Can I just check. In the pseudo code below, assume Col1...

Thanks again for your help. I found this in the mean time which does the job too.

IF OBJECT_ID('#DirTree') IS NOT NULL

DROP TABLE #DirTree

CREATE TABLE #DirTree (

...