Imagine if the table were normalised. Something like this:

(Id, Mode, StartDate, EndDate)

I think you'd need a query like:

select id

from table

where Mode = 1

except

select id

from table

where

(Mode = 2 and Enddate...

Nice one Jeff 😎

Have you considered setting the columns to NOT NULL?

(After fixing existing NULLs, of course)

Just played around with this a bit and it seems that the CHOOSE function does not deal well using functions directly in the 'index' argument.

This is not just a consequence...

batgirl (1/5/2015)

---

I have a grand plan for 2015!

1. Downgrading my "job" - this is my last week of a full time high pressure job (on call 24 x 7) and...

Ah, now I understand.

Go to Tools/Options in SSMS. Select SQL Server Object Explorer / Scripting.

Set 'Check for object existence' to False.

'Scripting' is how stored procedures are modified – it is the only way.

m_swetz (1/4/2015)

---

We have recently started using SQL Server 2012. Given that we have multiple servers running 2008, we continued using our custom SSIS logging reporting process to monitor the...

You cannot configure the connection directly like that.

Please read through this [/url]article and see whether it helps you.

Any solution proposed here will, of course, need to modified to run against your data, but...

Eirikur Eiriksson (1/3/2015)

---

Be careful with the implicit conversion as the results will be depending on the system settings, no guarantee that it will be...

Eirikur Eiriksson (1/3/2015)

---

Phil Parkin (1/3/2015)

---

By the way, this is not a great idea:

Rather than @@Identity, you would be...

Please post the full text of the error message you receive.

By the way, this is not a great idea:

Rather than @@Identity, you would be better off using Scope_Identity()....

Does your source header data include a natural key which you could use for lookup purposes after writing to the parent table?