Simpler:

SELECT *

FROM (SELECT col1 = 1, col2 = 2, col3 = 3, col4 = 4) s

CROSS APPLY (

SELECT MAXmyval = MAX(d.myval)

FROM (VALUES (col1), (col2), (col3), (col4)) d (myval)

) x

BWFC (6/24/2016)

---

I can't believe it either.

Farrago has already admitted that the £350 million figure, upon which many people based...

GilaMonster (6/24/2016)

---

Ed Wagner (6/23/2016)

---

Phil Parkin (6/23/2016)

---

Jeff Moden (6/23/2016)

---

On the "Brexit" thing, the folks in GB really need to consider the ramifications to their automotive industries. The EU has a...

Or this:

DECLARE @pString VARCHAR(8000) = '-[ab]+[cd]-[ef]';

WITH E1(N) AS (

SELECT 1 UNION ALL SELECT...

Can it be any of these?

'-[ab]+[cd]-[ef]'

'+[ab]+[cd]-[ef]'

'[ab]+[cd]-[ef]' (first element defaults to '+')

kyagi.jo (6/23/2016)

---

Thanks! This doesn't seem to work quite right when the first value is negative as I get a positive empty entry, but it gets me nearly there, so I'll...

Haha! The OP doesn't 😀

Oh I see - I got completely the wrong end of the stick, I assumed you were looking for a means of speeding up the function. To that end, here's...

kyagi.jo (6/23/2016)

---

Something like "[ab]+[cd]-[ef]" would create a mini-table that would have a row for "ab", "cd", "ef", and tell you that "ab" and "cd" were positive, and "ef" is negative....

What might be typical inputs and outputs of this code?

squvi.87 (6/23/2016)

---

Luis Cazares (6/22/2016)

---

You could use the Quirky Update. Be sure to read and understand the following article as you might get this wrong if you don't know what you're...

and what consumes those rows? What are you going to do with...

squvi.87 (6/22/2016)

---

Test data is...

SELECT

a.ID, a.TestDate, a.Score,

b.dt AS dates

FROM Calendartable b

OUTER APPLY (

SELECT TOP 1 a.ID, a.TestDate, a.Score

FROM testdata a

WHERE a.TestDate <= b.dt

ORDER BY a.TestDate DESC

) a

Brandie Tarvin (6/22/2016)

---

Beatrix Kiddo (6/22/2016)

---

Me too, and ashamed of the xenophobes.

Back to SQL Server, I work for a company that has a lot of trading systems. We are...