This assumes that you have no middle name, not mrs, ms, jr, snr....

DECLARE @Name AS VARCHAR(75)

SET @Name = 'RGRus, Ninja'

SELECT LEFT(@Name, CHARINDEX(',', @Name) - 1) AS LastName, RIGHT(@Name, LEN(@Name) -...

I thaught we couldn't explicitly create stats on table variables?

Have you run the dbcc check db() and other dbcc commands to see if anything comes ups.

Any possibilities that the disk may be corrupted (doubt it but I got nothing...

I'd go with your hunch at this point (cause I have none of my own ).

Try changing to left/right join syntaxe for the...

Just what exactly do you know you have bad records?

It's better to use the >= AND < operators for such a query.  You will lose any index seek chance if you use year(DateCol) = ...

I try imagine myself if I hadn't read all those posts...

I just can't .

None... I'm still has baffled as you are.  Waiting anxiously to see the conclusion of this one!

Rants!, What rants?

I rarely do too.... but the answer is alway no untill you ask .

Never had that problem... Have you tried to MS certified way of resolving this?

Close and restart?

Are you sure you have the same set options in both connections?

Except YOU DON'T NEED THAT!

http://www.sommarskog.se/dynamic_sql.html

http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/arrays-in-sql.html

.

I keep rereading this thread and I still don't see it.  But I guess it would make sens and since I have 0 experience with queue I'll take a step...

I can't tell you why but I know it does it.  Never had any problems other than I don't like the _1 at the end of the name, so I...