The error seems to be the CAST() functions. Use TRUNC() as you did on your column list.

For SQL Server, you can't use UNIQUE or TRUNC(), for Oracle your can't use...

I'd suggest you to use extended events. There are many places where you can find information about how to do what you want.

If Column2 is a Date column, you need to assign a complete date. The year is not a date, it's an integer value. If you want to change the data...

marin-231997 (2/22/2016)

---

Hello all,

I have encountered following problem lately:

when an insertion script is done via

INSERT INTO myTable (col1,col2,col3) VALUES ('TEST1','TEST2',NULL)

the value NULL will be somehow automatically embedded in square...

Jabba1963 (2/22/2016)

---

Looked at the article and slightly confused as to how to utilise the function... no I lie - correction - I am very confused since I am not delimiting...

Sean Lange (2/22/2016)

---

TSQL Tryer (2/22/2016)

---

ALTER PROCEDURE [dbo].[usp_test_Arrears_BrokenArrangement]

@PolicyId INT, @AccountId INT, @PolicyNodeId INT, @output BIT OUT

AS

BEGIN

SET NOCOUNT ON;

SET @AccountId = 1

DECLARE @CurrentArrangement as bit

DECLARE @LastSystemActionId as int

DECLARE...

Sweet dreams

FWIW, even if the comments aren't overwhelming in the code posted, some might be prevented and the code can be improved to be almost self documenting.

-- Insert into tblclass any...

djj (2/22/2016)

---

Luis Cazares (2/19/2016)

---

Ed Wagner (2/19/2016)

---

GilaMonster (2/19/2016)

---

SQLRNNR (2/18/2016)

---

I am seeing people claim to be an MCM for some of these interviews. I know full well they aren't an MCM. I...

Ed Wagner (2/22/2016)

---

Luis Cazares (2/19/2016)

---

Ed Wagner (2/19/2016)

---

GilaMonster (2/19/2016)

---

SQLRNNR (2/18/2016)

---

I am seeing people claim to be an MCM for some of these interviews. I know full well they aren't an MCM....

Ed Wagner (2/19/2016)

---

GilaMonster (2/19/2016)

---

SQLRNNR (2/18/2016)

---

I am seeing people claim to be an MCM for some of these interviews. I know full well they aren't an MCM. I have also been...

TomThomson (2/19/2016)

---

Luis Cazares (2/19/2016)

---

Hugo Kornelis (2/19/2016)

---

Jeff Moden (2/19/2016)

---

In that same vein, I also won't work for a company that requires you to pass an "intelligence test" or "personality test". ...

Chitown (2/18/2016)

---

I have thought about setting the notification for successful runs...

Hugo Kornelis (2/19/2016)

---

Jeff Moden (2/19/2016)

---

In that same vein, I also won't work for a company that requires you to pass an "intelligence test" or "personality test". They should automatically...

A story about Andy playing with a small girl using little green army men? I feel like I've seen that somewhere else. A movie perhaps? 😀

Thanks for the nice editorial.