You'll have to admit that my While loop is more succinct, and the end result is the same.

I checked the execution costs, and they are identical (50/50)

snootchie bootchies.

There you go...use underscores instead of spaces.

declare @String varchar(255)

set @String = 'Have________a_____nice_____day'

While 1 = 1

begin

set @String = replace(@String, '__', '_')

IF charindex('__', @String) = 0 Break

end

select @String

Well, in this case you WOULD need a loop 🙂

It seem like the extra whitespaces are being stripped out of the HTML. Is that a bug?

declare @String varchar(255)

--The string...

Well, color me red! Uh, yeah, no need for a loop; for some reason I was thinking double spaces would need it.

duh.

Haveaniceday!

That's to complicated. This works beautifuly.

declare @String varchar(255)

set@String = 'Have a nice day'

While 1 = 1

begin

set@String = replace(@String, ' ', '')

IF charindex(' ', @String) = 0 Break

end

select @String

Definitely adding the choices of "AND" and "OR" will not cause you to many problems. Most users are familiar enough with boolean logic to get by.

Adding parenthesis to allow...

You can make this relatively straight forward. I'm assuming you're running a daily report of some sort and you want a new date stamped file every day.

1) Manual step -...

Before my dba/webdev days I was a "Configuration Manager" at Nordstrom.com. That title didn't do to well in 2K, let me tell you.

Bob: ...

Here is Seattle they let us pump our own gas. Isn't big bro nice? I swear, there's all this crazy stuff going on and people make rules about...

lol...good stuff, good stuff.

You know, my cell phone has a case sensitive search...most annoying thing ever. Not only that, but the default for entering names is different than the...

Yeah, that looks great! Even with a un-indexed view it should run faster than row by row processing.

Is there any reason you need to check each company_id separately? ...

Man, that power outage was some crazy stuff. Only inevitable a complex self-referencing system, though (Chaos!). I heard people were being pretty cool about things, though; probably have...

Mccork,

What am I looking at when I run "DBCC MEMUSAGE"? dbid and objectid I got, but units of measurement is "Buffers", and what's "Dirty"?

Quote: No - you will have to specify specific columns for IsNull.

Nah, as long as you make it dynamic. Just set the variable @Table to your table name...

Oh....my....god.

The use of "would" instead of "will" certainly implies "in this current state".

Sometimes the syntax isn't important:

select distinct nitpick

from Prog

select nitpick

from Prog

group by nitpick