In T-SQL, you cannot refer to "a field" in a table by its "index".

However, you can use dynamic sql o build a relevant update statement using table definition details...

Another way:

SELECT S.*

FROM SAMPLE S

CROSS APPLY (SELECT MAX(dt) mxd, MIN(dt) mnd FROM (VALUES (a),(b),(c),(d)) as v(dt)) A

WHERE A.mxd != A.mnd

I've couldn't run OP code in SQL2008 as he is using 2012 function.

Now, I can see what is result of his query.

The following will produce the same:

select *

...

webrunner (7/25/2013)

---

Thanks, Eugene, I see. I had commented out the ROLLBACK for my INSTEAD OF trigger so didn't understand the behavior you just posted with the test code. Perhaps Scott...

ScottPletcher (7/25/2013)

---

Eugene Elutin (7/25/2013)

---

Alexander Suprun (7/24/2013)

---

It's so untrue...

RAISERROR has nothing to do with the...

webrunner (7/25/2013)

---

Eugene Elutin (7/25/2013)

---

webrunner (7/25/2013)

---

ScottPletcher (7/24/2013)

---

webrunner (7/24/2013)

---

Alexander Suprun (7/24/2013)

---

Remove ROLLBACK from the trigger and lower severity of RAISERROR to 10, in this case SSMS won't show any errors, rows will...

webrunner (7/25/2013)

---

ScottPletcher (7/24/2013)

---

webrunner (7/24/2013)

---

Alexander Suprun (7/24/2013)

---

Remove ROLLBACK from the trigger and lower severity of RAISERROR to 10, in this case SSMS won't show any errors, rows will disappear from the...

John Mitchell-245523 (7/25/2013)

---

This indeed returns 0:

SELECT CAST('' AS int)

It's just the way it works. I suppose when the DBMS or the standards were being written, somebody decided that ''...

Lowell (7/25/2013)

---

doh!, if it ends in [0-9] might be even easier?

SELECT *,

CASE

WHEN x LIKE '%[0-9]'

THEN 1

...

Lowell (7/25/2013)

---

probably very similar, using reverse and patindex for the first non numeric character: from there, for the 1/-1, a case based on the len() would be what i would...

Test it!

If it's executes wihtout error that mean your code is valid.

Check if results do match expected results. If so, your code is correct.

The same question from past!

You will see my response there too...

http://www.sqlservercentral.com/Forums/Topic1305828-391-1.aspx

Alexander Suprun (7/24/2013)

---

It's so untrue...

RAISERROR has nothing to do with the transaction.

It's just the...

...

select *, ISNULL(CAST(SUBSTRING(x,NULLIF(PATINDEX('%-[0-9]%',x),0) + 1,1) AS INT),-1)

from tmp

Koen Verbeeck (7/25/2013)

---

Identity is not the data type, INT is.

The identity property specifies that this column is autopopulated by an integer, starting at 1 and adding 1 for each new...