I strongly vote against the NOLOCK hint!! It's not a "magic run-faster" option. For moredetails about the concequences search this site or google for "nolock hint dirty reads".

My guess would...

If it's a performance issue you might consider to recreate the table with the proper collation and copy the data into the new table (as already suggested). Rename the table...

Oksana March (11/26/2011)

---

Personally, I hate when people tell me to "Google it" or look in Books Online (everyone knows already there is that option, why remind?) Therefore, I'll try to...

I'd rather go with the classic CrossTab approach (see related links in my signature).

The code is not only easier to read and to expand (e.g. to include "nested" pivots), it's...

Can you open the linked tables in Access?

Can you create a new view using the linked tables?

I just came across this link (Replicating Excel 2003 Formulas to SQL Server).

Might be worth looking into it.

A google search provided quite a few links claiming to provide an Excel-like functionality.

Some of the solutions are CLR based and should return the correct result. ("correct" in terms of...

There's only one person being able to answer that 😉

But the chances on your side aren't too bad...

If all the code I provided does is to show how important consistent...

@Cadavre: Your code returns 2011-10-31 which is not part of the expected result.

I'd throw a DISTINCT into the ring:

SELECT DISTINCT Date2 AS DateOutput FROM @TABLE

If the queue is "overloaded" it usually means there is no process receiving the messages.

Deleting the queue is not really the way the messages should be "cleared".

Rusanus blog[/url] might help...

There's simply not enough information...

What exactly do you mean by "getting slow"?

You'll need to figure out if there are specific queries getting slower and where those queries get the data...

Are you sure SSIS is the right tool to do it?

CSV is a rather straight forward format of Excel. But Excel is not really a database source...

A short VB script...

SELECT Date2 AS DateOutput FROM YourTable ??

It's most probably not the code you're looking for, but it's a valid solution based on your sample data... You might want to be...

SELECT STUFF(CONVERT(VARCHAR(11),CONVERT(datetime,'20071015',112),113),1,3,'')

As a side note: "ASAP" is not really among the preferred phrases on this site... It's usually combined with the word "money" 😉

Edit: two more issues:

1) it's highly recommended...

Revenant (11/24/2011)

---

This may or may not be correct.

What does it mean, "since last year"?

As of this moment, GETDATE() will return 11/24/2011 12:45 and some seconds.

Do you want data from 11/24/2010...