The real solution is on my website. You just need two more replace statements like so:

declare @String varchar(255)

declare @new_string varchar(255)

declare @cmd nvarchar(1000)

declare @replace_value varchar(10)

set @String = 'Have__________________________________________________________________________________________________________________________________________________________________________________________________________________a nice day'

set...

Darn HTML, here it is with underscores:

set @cmd = 'set @new_string = replace(replace(replace(replace(replace(@String,' +

'''_____'', ''' +...

A loop is not required to remove multiple white space. You can do it with just a number of replace statements like so. Actually I made this even more...

Question. If you are replacing all the spaces with no space with the command "replace(@String, ' ', '')", then why do you need the while loop, with the break...

So installing a patch like MS03-033 does not require you to test your applications. Right? Or at least the testing is a much smaller effort than MDAC 2.8....

Here is another way:

-- create tables

CREATE TABLE test(col1 int, col2 char(1))

-- populate the table

insert into test values(1,'a')

insert into test values(2,'b')

insert into test values(1,'d')

insert into test values(3,'a')

insert into test values(2,'c')

--...

Here is a method to remove large amounts of White space in a with a single commands that contains multiple REPLACE clauses:

http://www.geocities.com/sqlserverexamples/#string2

Gregory Larsen, DBA

If you looking for SQL Server Examples...

I have found the WinZip will not compress large backups. I think the size limit of the compressed file is 2 gig. Does Litespeed have this size limitation on...

I should have known there would be a debate over the GOTO. Well I suppose a GOTO is considered bad if it makes the logic of your code hard...

You could try the GOTO command like so:

declare @i int

set @i = 0

while @i < 60

begin

set @i = @i + 1

print @i

if @i >...

One way to do it would be to have multiple ALIAS that point to the same server. Then you can register each ALIAS in Enterprise Manager. ALIAS's are...

Guess I should have read your original post a little closer. Here is another way that creates a flat file and then loads using bulk insert. I tested...

You might try a simple insert with a union statement like so:

set nocount on

create table old_table(id int, field1 char(1), field2 char(1), field3 char(1), field4 char(1), field5 char(1))

create table new_table...

Here is another article that might help:

http://www.databasejournal.com/features/mssql/article.php/2235081

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Very good information, and advice.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples