Note that UNION will remove any duplicates. To avoid this problem and receive a possible performance improvement, use UNION ALL.

Why would you have a 100GB database in a developer workstation?

I agree that improving the query would help. As you say that you can't at this moment, you should start...

Databases don't have backward compatibility. Once you restore or attach a database to a version of SQL Server, you can't restore it or attach it on a previous version.

Are you seriously asking how to change the query to return 1 day instead of 14? Do you even know how does your query work?

Also, I'm not sure what you...

Well, considering that it has been 6 years now since the "accidental...

That's great! Do you understand how or why does it work?

Where?

I submitted the article, I'm not sure if it is what you had in mind or if I should have taken a different approach.

Have you replaced the splitter?

Can you share the execution plan and performance results with the new splitter?

If you refer to this...

Clock

Or this:

declare @myDate datetime;

set @myDate = cast(dateadd(day, -1, getdate()) as date);

SELECT *

FROM [ThomasSci].[dbo].[tsi_gdserial_vw]

where date_shipped >= @myDate

AND date_shipped < DATEADD( dd, 1, @myDate)

order by

order_no desc,

...

Or you could do it directly in SSIS

Use the REPLACE() function.

This response is intentionally vague to match the vague requirements posted.

Sean Lange (8/19/2015)

---

I am working on putting together my first SSIS package. I haven't done this type of thing since it was still DTS packages. This stuff is a LOT...