Viewing 15 posts - 10,726 through 10,740 (of 18,923 total)
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) -...
December 5, 2006 at 8:41 am
I thaught we couldn't explicitly create stats on table variables?
December 5, 2006 at 8:31 am
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...
December 5, 2006 at 8:29 am
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...
December 5, 2006 at 8:28 am
Just what exactly do you know you have bad records?
December 5, 2006 at 8:21 am
It's better to use the >= AND < operators for such a query. You will lose any index seek chance if you use year(DateCol) = ...
December 5, 2006 at 8:20 am
I try imagine myself if I hadn't read all those posts...
I just can't
.
December 5, 2006 at 8:19 am
None... I'm still has baffled as you are. Waiting anxiously to see the conclusion of this one!
December 5, 2006 at 7:54 am
I rarely do too.... but the answer is alway no untill you ask
.
December 5, 2006 at 7:38 am
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?
December 5, 2006 at 7:36 am
Except YOU DON'T NEED THAT!
http://www.sommarskog.se/dynamic_sql.html
December 5, 2006 at 7:22 am
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...
December 5, 2006 at 7:12 am
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...
December 5, 2006 at 7:08 am
Viewing 15 posts - 10,726 through 10,740 (of 18,923 total)