Viewing 15 posts - 44,551 through 44,565 (of 59,063 total)
RBarryYoung (3/14/2009)
OK, this is the most disturbing thing that I have read in a while. Read it closely. Brrrr...
Oooooh myyyyyy.... absolutely chilling. "Forgive them, Lord, for they...
March 14, 2009 at 11:50 pm
foxjazz (3/14/2009)
I haven't experienced a case where I could write a stored proc, without t-sql language .... I would love to write my stored procs in c#.
foxjazz (3/14/2009)
March 14, 2009 at 11:46 pm
RBarryYoung (3/14/2009)
Jeff Moden (3/14/2009)
RBarryYoung (3/14/2009)
I know that this'll drive Jeff crazy, but I actually think that this would work better as a CLR Trigger.
It might... but Nah... "we don need...
March 14, 2009 at 11:19 pm
Here's the code with the last step of counting the actual words...
--===== Replace all HTML tags with nothing
WHILE CHARINDEX(' CHARINDEX('<',@HTMLText)
SELECT @HTMLText = STUFF(@HTMLText,
...
March 14, 2009 at 11:15 pm
Sorry Goldie... I forgot the last step... I'll be right back...
March 14, 2009 at 11:02 pm
RBarryYoung (3/14/2009)
I know that this'll drive Jeff crazy, but I actually think that this would work better as a CLR Trigger.
It might... but Nah... "we don need no stinkin' CLR"...
March 14, 2009 at 11:01 pm
As much as I praise their use, there are some things that the Tally table won't beat a WHILE loop at... cleaning strings using STUFF is one of those things...
March 14, 2009 at 10:56 pm
Goldie Graber (3/14/2009)
Download the file and save as text.If you try to view it in your browser it will translate the HTML tags.
Ack... of course... stupid me. Thanks, Goldie.
March 14, 2009 at 9:37 pm
Joseph (3/14/2009)
WITH CITY_INFO(stateid ,cityid,districtid,distpt,citypt
(
select stateid ,
...
March 14, 2009 at 9:35 pm
Bob Hovious (3/14/2009)
March 14, 2009 at 9:32 pm
lmu92 (3/14/2009)
@ Jeff:Jeff Moden (3/14/2009)
Heh... definitely not. English only here.I wouldn't be so sure about that... 😛
Heh... sorry... the "here" means "me" in this case. I understand...
March 14, 2009 at 9:28 pm
megham10 (3/13/2009)
I 'm Using Bulk insert Statement to load .CSV File into temp table.
one of my field contains data as eg."23,446" so while inserting it treats it as two...
March 14, 2009 at 9:15 pm
Bob Hovious (3/12/2009)
I think we've caught Moden's Millisecond Madness.
Heh... you must have... you're getting good at it. 😉
The performance key here isn't the number of milliseconds of difference between the...
March 14, 2009 at 9:05 pm
Heh... stupid me... of course it's set to 9 or you'd have gotten a message about the CTE. Sorry.
Can you post your final code? I just wanna make...
March 14, 2009 at 8:59 pm
siddartha pal (3/12/2009)
I am not able to complie the function because of Varchar(max) for @string parameter.
Siddartha,
Check the compatibility level of the database... if it's set to "8", then the database...
March 14, 2009 at 8:28 pm
Viewing 15 posts - 44,551 through 44,565 (of 59,063 total)