OK, so you do indeed have stray characters in the rows. IsNumeric=0 means all values have non-numeric data of some sort.

Try this:

DECLARE @OriginalText NVARCHAR(50)

SELECT @OriginalText = MyColumn

FROM ...

Dedicated SQL Server box replicating to dedicated SQL Server box. Both on VM, both 32-bit.

Publisher/distribution server has 8 GB max configured in VM, 6 GB max server memory in...

A very kludgey way to check, but try:

Select '*'+TheColumn+'*' from The DB

that will tell you if there are any stray characters.

Also, check out the IsNumeric function. While not perfect,...

What is the column's collation (can be different from the database)?

What is the server-level collation?

Above solution is probably the best if it fits your real script. Otherwise, remember your basic algebra. Parentheses are your friend.

So you can do things like...

SELECT *

from My...

Simplest solution, really is to look at sp_send_dbmail. Set up one command into a job and it will run the query and mail it off to whoever you tell...

Yup. Look up sp_send_dbmail in online help. Should be just what the Dr. ordered.

The parsing of the rows is the issue, as the only way that I can find is to check the characters in the string for every column that might have...

It's not ASCII, it's Unicode. Values go up to 65533 (decimal). Which, by the way, we do get.

Random sampling via PATINDEX is no good.

Conrad,

Make sure your VM environment is set up properly for SQL Server. We had some huge performance issues that sound very similar to yours when we virtualized a particular...

Thanks, Wayne. I keep wanting simpler but I don't think it's possible. Mostly wanted a sanity check.

Maxim, I thought about going that way as well but I like...

Also to note is that partitioning is only available in the Enterprise edition of SQL Server.

I'm sure there are more elegant/complete ways of doing this, but it gets you close. If you combine this with PIVOT it would work.

;

WITH Totals (...

I would start by putting all that date math into declared variables.

Same for the AsOfDate value.

So how are you defining the characters you want to keep vs the characters you want to remove?