Just to expand on my other post, I used to get the latest instance of whatever I wanted, then use that latest instance as sort of a lookup key back...

What I used to do was select the latest test date for each...

Sean Lange (3/16/2012)

---

patrickmcginnis59 (3/16/2012)

---

jeff.mason (3/16/2012)

---

patrickmcginnis59 (3/16/2012)

---

Sean Lange (3/16/2012)

---

Nice easy question. Unfortunately the choices are worded such that none of them are really correct. The biggest issue is this is testing...

jeff.mason (3/16/2012)

---

patrickmcginnis59 (3/16/2012)

---

Sean Lange (3/16/2012)

---

Nice easy question. Unfortunately the choices are worded such that none of them are really correct. The biggest issue is this is testing syntax on a...

Sean Lange (3/16/2012)

---

Nice easy question. Unfortunately the choices are worded such that none of them are really correct. The biggest issue is this is testing syntax on a construct that...

SQL Guy 1 (3/7/2012)

---

Are there any benefits of C# vs VB ? In other words, can C# do sometheing that VB cannot do ? Assuming same version of .NET...

jackimo (3/9/2012)

---

Here's a bit more information,

The two sp's are vendor supplied. They have given me the 2 procs and when they run in Management Studio they run exactly as...

jackimo (3/9/2012)

---

Sorry for the lack of info. The issue being that there are two very long stored procedures involving hundreds of tables. I think my issue is more...

slash3584 (3/9/2012)

---

I have this table named EXE with 2 fields: NAME and QTY. What I want to do is group by NAME all the positives (QTY>0) and negatives (QTY<0)

So...

jackimo (3/9/2012)

---

I'm running two stored procedures that basically copy data from one database into another. When I run them using Management Studio they finish with errors but the data...

R.P.Rozema (3/2/2012)

---

Just for the sake of the discussion, because this is a useless alternative for the OP's question. You could make it execute the max(len()) only once like this:

SELECT LEFT(t2.TEXTFIELD...

Jeff Moden (3/2/2012)

---

R.P.Rozema (3/1/2012)

---

That's...

David Lean (9/21/2010)

---

Nice article & Nice solution. But I would caution anyone about to blindly using this in production. It is only the 1st part of the process.

Problem 1:...

GSquared (2/27/2012)

---

patrickmcginnis59 (2/27/2012)

---

Well I asked for a clarification this week on a post, and the poster replied that he was sorry I wasn't able to understand his post, and he...

Well I asked for a clarification this week on a post, and the poster replied that he was sorry I wasn't able to understand his post, and he wouldn't be...