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?

--Edit: bad solution removed:-)

Viewing the XML for the execution plan, there are references to the CONVERT_IMPLICIT() function.

Thanks Luis

On 2014, I get exactly the same execution plan for both 1 and 'true'. And no implicit conversions.

--Edit

Each statement seems to be converted to

SELECT * FROM [bitTest] WHERE...

Steve Jones - SSC Editor (1/2/2015)

---

I don't think there's an issue here. There might be a small conversion, but it can't be much. There can't be a "bit" in the...

Eirikur Eiriksson (1/2/2015)

---

Quick thought, don't think that in this case it makes any difference, looked into this quite a while back and I couldn't find any implicit conversion in the...

You could use something like this one to get rid of weekends.

To exclude your other non-work days, simply

select count(*)

from ih_non_work_days

where [apply start and end date filter here]

And subtract this...

Why not just configure the Foreach Loop to crawl through all the subfolders? No scripting required.

If you mean the management tools, you should follow the link I sent previously....

Now it's my turn to be stumped! I don't know what you mean.

Are you aware that the import wizard creates a package "behind the scenes" & then runs it?

As you...