Lynn Pettis (7/22/2012)

---

Realizing I have an unnecessary join, this would also work:

if exists(select 1

from sys.indexes i

...

Yes, but I'm trying to create the Index without error regardless of whether the Index Exists or not.

So correct me but I don't believe that you directly answered my question?

I determined that if the Index does not exist you will get the error no matter what.

You have to first create the Index and then execute with that option.

Did it work on not?

I get different results and it appears to be machine dependent.

Whan I said flag them as inactive I dod not mean to store an "Inactive Flag", I mean to indicate that they were inactive as a particular Date, etc.

Thanks for the responses.

I totally agree and understand that you do not want to delete records but flag them as inactive.

As far as the OUTPUT Clause could you please go...

richykong (7/20/2012)

---

Depends on your ETL process to load from staging to target, but you should be able to capture INSERT/UPDATE/DELETE records from the ETL process. I used the MERGE...

Sean,

That is a very straight forward script.

Thanks.

It recovered.

Oh shucks my Student free delivery for FedEx & UPS (United Parcel Service) for two day delivery just...

I'm looking for a very simple example on Data hashing in SQL Server.

Thanks.

Does someone know of a good white paper on the hash option to encryption?

I typed 32 GB of memory, it is 4 GB of memory on a 32 bit OS.:w00t:

Thanks for all of the information.

I could do an in Place Upgrade to the OS to Enterprise Edition.

Has anyone tried that and what was the outcome>

You are getting an error on the ModifiedDate.

A Record(s) in the Source Column for ModifiedDate is too large.

What is the largest value for that column in your flat file.

Have you...