It isn't that duplicate posts aren't allowed, we just really frown on it as it tends to split responses across multiple threads and makes things a bit confused.

I just want...

Chris Wooding (10/27/2016)

---

Just as an aside; I have got into the habit of using the "Script as create" instead of "Script as alter" or "Modify" options when looking at stored...

May help others going forward (I haven't read your post, so buyer beware), but for the OP this is a 7...

Pretty broad question. One, what does this have to do with Microsoft SQL Server? Two, what software are you talking about and how is it related to MS...

When you say it isn't working, what do you mean? It doesn't return what you expect, you are getting an error or errors?

Luis Cazares (10/27/2016)

---

Here's an example of the different behavior of ROUND and CEILING/FLOOR.

WITH SAMPLE_DATA (SD_ID,SD_VAL,SD_EXPECTED) AS

(

SELECT 1, 0.1, 30 ...

Eric M Russell (10/27/2016)

---

Lynn Pettis (10/27/2016)

---

Gary Varga (10/27/2016)

---

I have found that telecommuting is never the problem. The individual, the company, the management and the infrastructure can all be problems. The...

Jeff Moden (10/27/2016)

---

Brandie Tarvin (10/27/2016)

---

All right, everyone. I think now is a good time to back away from this thread. Obviously there's been several misinterpretations of who has posted what...

Gary Varga (10/27/2016)

---

I have found that telecommuting is never the problem. The individual, the company, the management and the infrastructure can all be problems. The right person with the right...

Jeff Moden (10/26/2016)

---

Sterling Ostin (10/26/2016)

---

Sergiy,

I did read Luis' post and incorporated it in an even more graceful and shorter solution that best suited my need.

In the future, maybe you ought...

Sue_H (10/26/2016)

---

Another option...

You can use the values clause to get min and max values across a row but YMMV. I've had case statements outperform it at times and other times...

This is my version since there was no explicit request to know which column the date was returned from.

SELECT MT.CaseID, MA.MinDate

FROM @datetest AS MT

OUTER APPLY (

SELECT MIN(VA.DateCol)

...

Sterling Ostin (10/24/2016)

---

Jeff - Look at the fourth and sixth small paragraph of my original post. I did exactly what you are suggesting I did not do. I...

Spammers are getting better, now even the topics they post look legit.

jasona.work (10/25/2016)

---

Lynn Pettis (10/25/2016)

---

jasona.work (10/25/2016)

---

Brandie Tarvin (10/25/2016)

---

jasona.work (10/25/2016)

---

So this ought to be fun...

Dev asked me to take a look at a view that isn't performing as well as it did...