Cadillac

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 UNION...

Quick correction.

WITH SAMPLE_DATA (SD_ID,SD_VAL,SD_EXPECTED) AS

(

SELECT 1, 0.1, 30 UNION ALL

SELECT 1, 10.1, 30...

Ed Wagner (10/26/2016)

---

I admit that's very tempting, but I don't want to get drawn into a battle of sarcastic remarks that have nothing to do...

That's right, you need to replace the zeros with the columns available.

To obtain the data in the new way (which should be the correct way to store it) you need...

Actually, it's not precisely a cross tabs issue, but some kind of unpivoting.

Here's an example which is partially explained in this article: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

SELECT [Customer], [Section], [Data], [Year], Jan, Feb, Mar,...

Is this Oracle? :crazy:

Deries (10/26/2016)

---

Luis, Thank you for the code and the suggestion. Really Appreciate it. We need to show hours in the secondary table as in the front end GUI we got...

Here's a bit simpler version of DesNorton's query.

SELECT MT.CaseID, MA.MinDate, MinDateCol = MA.ColName

FROM @datetest AS MT

OUTER APPLY (

SELECT TOP(1) VA.ColName, VA.DateCol

FROM (VALUES('MTDThresholdDate', MT.MTDThresholdDate),

...

Why do you want to store the data 24 times?

You can achieve the result without having all that data stored. It's just a waste of storage when a query will...

Now, that's weird. Have you tried reseeding the identity value?

I'd post the syntax but I'm on my phone right now.

DesNorton (10/25/2016)

---

The correct covering index also takes care of the order...

Phil Parkin (10/25/2016)

---

Luis Cazares (10/25/2016)

---

However, the OUTPUT clause will generate an empty result set when no rows are updated, so that should work.

And with a single statement and the error...

However, the OUTPUT clause will generate an empty result set when no rows are updated, so that should work.

And with a single statement and the error handling just throwing the...

The reason for the CTE was to include the ORDER BY which isn't available in the simple UPDATE.