Viewing 15 posts - 44,536 through 44,550 (of 59,063 total)
Oh yeah..l. I forgot. Never use BETWEEN for date comparisons of this nature because you never know when someone is going to include a time in the column along...
March 16, 2009 at 7:26 pm
[font="Courier New"] WHERE yourdatecolumn >= DATEADD(mm,DATEDIFF(mm,0,GETDATE())-1,0)
AND yourdatecolumn < DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)[/font]
March 16, 2009 at 7:25 pm
Goldie Graber (3/16/2009)
Jeff Moden (3/16/2009)
One of your requirements was to ....
4. Replace all entity codes (“&xxx;”) with X
If you "smear" that requirement across...
March 16, 2009 at 6:15 pm
Goldie Graber (3/16/2009)
Jeff Moden (3/16/2009)
Goldie Graber (3/16/2009)
I can't seem to get better performance than my original function.I'm pasting it here for future reference.
Do you have the code for the new...
March 16, 2009 at 6:05 pm
Goldie Graber (3/16/2009)
I can't seem to get better performance than my original function.I'm pasting it here for future reference.
Do you have the code for the new function... I know it...
March 16, 2009 at 3:12 pm
RBarryYoung (3/16/2009)
Jeff, do you have a test set for this?
Only the "single line" of HTML Goldie previously attached a couple of posts back...
March 16, 2009 at 3:10 pm
Bob Hovious (3/15/2009)
March 16, 2009 at 9:30 am
By the way, Goldie... no special test is required for the non-breaking space because of the way I detect characters that need to be replaced with a space.
March 16, 2009 at 9:08 am
Goldie Graber (3/15/2009)
I'm going to test it out at work tomorrow.
One part I don't quite understand is this:
--===== Replace all EntityCodes with the actual ascii character...
March 16, 2009 at 8:58 am
Yep... I agree... knowledge and time are part of the real world items that are frequently missing in that area. Like Perry stated, I just don't want anyone to...
March 15, 2009 at 9:22 am
megham10 (3/15/2009)
my field is like "Field"(Surrounded by "").But how to make BCP Format .Pls guide me.
Sergiy is correct... OPENROWSET or a text based linked server may do the trick easily....
March 15, 2009 at 9:15 am
Adi Cohn (3/15/2009)
You can find an explanation here – http://msdn.microsoft.com/en-us/library/ms191516(SQL.90).aspxAdi
Unfortunately, the MS documentation on this subject doesn't tell you how to handle text qualified strings that use quotes with...
March 15, 2009 at 9:11 am
steve dassin (3/14/2009)
foxjazz (3/13/2009)
March 15, 2009 at 9:08 am
Jack Corbett (3/15/2009)
Barry,Just making sure you noticed, but Goldie said that the CLR is not an option in this case. I had suggested it originally as well.
Heh... yeah... but...
March 15, 2009 at 9:02 am
I'll also kick in that I'm amazed at the attitude of so many DBA's, especially System DBA's. The code is part of the server and bad code should be...
March 15, 2009 at 8:59 am
Viewing 15 posts - 44,536 through 44,550 (of 59,063 total)