Jeff Moden (3/2/2016)

---

So why not use the single proc with the 4,000...

Today is the first day I haven't got one in a long time.

Gary Varga (2/11/2016)

---

below86 (2/10/2016)

---

...you can check in code in VCS but it isn't in production...If code is checked in early like I mention above your 'true' version 'gold' code is...

Please feel free to enlightened me.:-) But from what I've seen so far, only a couple weeks now, you can check in code in VCS but it isn't in...

roger.plowman (2/5/2016)

---

below86 (2/5/2016)

---

I would like to live in your fantasy world. It sounds...

I would like to live in your fantasy world. It sounds so perfect....

Here is the reason I would NEVER EVER want to be on call for this type...

Phil Parkin (2/1/2016)

---

I'm with the DBA: the true version of code is what's in Production.

And if your development and release processes are strict enough, the version in SC will match...

You could use something like this to just find the max date of those columns, it won't get you the column name though. I found this on another site,...

Eirikur Eiriksson (1/20/2016)

---

below86 (1/20/2016)

---

Just a simple way I would try and get this:

CREATE TABLE #datetest

(

id varchar(8),

L1 date,

L2 date,

L3 date

);

INSERT INTO #datetest (id, L1, L2, L3)

VALUES...

Just a simple way I would try and get this:

CREATE TABLE #datetest

(

id varchar(8),

L1 date,

L2 date,

L3 date

);

INSERT INTO #datetest (id, L1, L2, L3)

VALUES ('1005', '1-1-16', '1-17-16',...

erics44 (1/6/2016)

---

jaime.simancas 27970 (1/6/2016)

---

erics44 (1/6/2016)

---

hmmmmmm, seems like a very profound...

jaime.simancas 27970 (1/6/2016)

---

below86 (1/6/2016)

---

jaime.simancas 27970 (1/6/2016)

---

erics44 (1/6/2016)

---

below86 (1/6/2016)

---

I've had to work with a group of contractors for over a year now, and I find their use of CTE's to be...

jaime.simancas 27970 (1/6/2016)

---

below86 (1/6/2016)

---

jaime.simancas 27970 (1/6/2016)

---

erics44 (1/6/2016)

---

below86 (1/6/2016)

---

I've had to work with a group of contractors for over a year now, and I find their use of CTE's to be...

Lynn Pettis (1/6/2016)

---

jaime.simancas 27970 (1/6/2016)

---

erics44 (1/6/2016)

---

below86 (1/6/2016)

---

I've had to work with a group of contractors for over a year now, and I find their use of CTE's to be excessive,...