You could try deleting the rows in batches. According to your recovery model, there'll be differences on how would you need to code it.

There should be a way to do it completely in SSIS, but you could create a table in SQL Server to query the correct path according to your dates.

You can change the CTE for a subquery.

I'm leaving 2 options in here. The problem is that you're formatting your date in different parts.

Date formatting should be done in the front end to avoid problems.

CREATE TABLE DateTest(

...

Just to add what Jack and Batgirl already said. Here's a little test that you can make. If you want to have an exact rounding, you need to use an...

If you're deleting all the rows from the tables, you might want to consider TRUNCATE.

Grant, Congratulations on being elected as a member of the PASS board!

The results grid will remove the line breaks, there's no way to change that. You need a front end that can display line breaks.

I'm not sure if a "WHEN NOT MATCHED BY SOURCE" would be what you need. It gives the expected result, but I'm not sure if it's the logic needed.

...

SQL Server stores the line breaks without any problem. One of your applications must be removing the line breaks.

Lynn Pettis (10/14/2014)

---

Without seeing the table structures (columns and definitions) or the execution plan (which will show what is happening) not much we can do to help.

It could be implicit...

ScottPletcher (10/14/2014)

---

I suggest a different method to avoid 2 or more decimal points:

AND CASE

...

You can also grant multiple permissions on a single instruction.

GRANT INSERT, SELECT, UPDATE, DELETE ON ObjectName TO UserName

Eirikur Eiriksson (10/14/2014)

---

Luis Cazares (10/14/2014)

---

That sounds like a good and bad news. And the good news sound great.

Thank you for the update, Steve.

In an unrelated topic, have you ever seen...

The best way to do this is by using TRY...CATCH... blocks.

Read more about them in here: http://msdn.microsoft.com/en-us/library/ms175976(v=sql.100).aspx

Or search on the internet for more information and come back with any questions...