--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...

KoldCoffee (12/31/2014)

---

I don't understand "saving the SSIS package produced by the import wizard"

the process of importing these files needs to be automated. Therefore, the object of the ssis package is...

Yes you can.

Have a look here and look for 'SQL Server Management Studio Express'

KoldCoffee (12/31/2014)

---

I wrote in my opening statement that I used Import Wizard and in resulting table there are no 'duplicates'

last evening I used bulk insert to import the .txt file...

Is this what you are looking for?

chrisn-585491 (12/31/2014)

---

As a Jack-of-All-Data-Trades, certification is huge time suck for me. As soon as I'm ready for an exam, it's retired and there's yet another two new versions of SQL...