Thanks Lowell. The NULL and the Or clause are business rules so won't be able to find my way around that.

I will try breaking the master proc and test with...

serg-52 (11/23/2015)

---

Using SQL generate a rowset containing all needed bcp commands and save it to a file.

Create vbscript kind of https://gallery.technet.microsoft.com/scriptcenter/32e0146a-83fc-4ee1-af7b-52a57d57466c to run commands from file in parallel using...

Paresh Motiwala (8/5/2015)

---

I have a similar case but the retention for the files is 14 days. The job once failed did not succeed at all.

I even copied one of the...

Grant Fritchey (7/27/2015)

---

chandan_jha18 (7/27/2015)

---

@Grant-

The code that I executed kept on running for more than 26 hours and appeared to be doing nothing. After putting in a lot of research...

@Grant-

The code that I executed kept on running for more than 26 hours and appeared to be doing nothing. After putting in a lot of research and reading on...

marizarocio (7/20/2015)

---

Hi all,

our MS SQL Server Administrator deleted / dropped our MS SQL Server database accidentally.

Is there any form to recover what was deleted? there is no backup of that...

Thanks Koen, John,Ken,Chris and Scott for all your suggestions. All the answers helped me to view the problem and its solution through different approaches.

Cheers!!

Koen Verbeeck (8/20/2014)

---

ScottPletcher (8/19/2014)

---

My preference would be this (the "extra" parentheses are important to properly match the requirements):

SELECT *

FROM YourTable

WHERE (SnapshotDate > @from AND SnapshotDate < @to)

OR...

ScottPletcher (8/19/2014)

---

My preference would be this (the "extra" parentheses are important to properly match the requirements):

SELECT *

FROM YourTable

WHERE (SnapshotDate > @from AND SnapshotDate < @to)

OR (SnapshotDate =...

Actually this looks pretty much...

John Mitchell-245523 (8/19/2014)

---

Chandan

It's not entirely clear what your requirement is, but if I understand correctly, I think the simplest solution is to use a CTE or add a computed column...

Thanks a lot. I...

Thanks Anthony and Eirikur. Both solutions are great. I will see how to use them in the package now so as to avoid conversions for such a massive 200 GB...

Thanks for your great solution using recursion. Now, I am in a spot of bother due to my own question. If I pre-populate the time frames lets say 1 year...

Koen Verbeeck (6/17/2014)

---

Just my 2 cents.

Wouldn't it be easier to just store the maximum entrydate you loaded in the last run.

Say you ran the initial load and the max entrydate...