Steve Kinnaman (6/11/2009)

---

Thank you Wayne. Thanks to you I even figured out how to retain the space in the swedish zip by adapting your script like this:

select ...

carissa.chris (6/12/2009)

---

I have a batch file that runs all the sql scripts in a specified folder. The output is written to output.txt. However, each time a sql script...

Whoops, I didn't notice that you were in the SSIS forum - I gave you a T-SQL solution.

I'll have to let someone that knows SSIS better answer this.

declare @CRLF = char(13) + char(10)

set @YourString = replace(@YourString, @CRLF + @CRLF, @CRLF)

I outline my favorite way in Using XML to Enhance the Performance of String Manipulations[/url].

Cynthia DuBose (6/11/2009)

---

Thanks Wayne -- but just to make sure, after deinstalling the Management Tools, how do I reinstall only the Management Tools? Will it automatically install ONLY the...

select

[ZIP] = replace(left([CAD3],6), ' ', ''),

[City] = substring([CAD3], 7, len([CAD3]))

from crm5.CAD3

Grant Fritchey (6/11/2009)

---

WayneS (6/10/2009)

---

Hey gang,

A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the...

Gail, thank you for jumping in and answering this for me. You knowledge of how indexes work far surpasses mine.

I assume you have data like:

declare @test table (colA int, colB varchar(50))

insert into @test

select 1, 'plain text' union

select 2, 'csv,data,in,this,row'

select * from @test

A properly formatted CSV file is not just...

You might also want to check the port. The default port is 1433, but you might have changed it during the installation. Or, the previous installation might have been different,...

This might help you out.

http://www.lmgtfy.com/?q=sql+server+2005+move+tempdb+site%3Amicrosoft.com

Cynthia DuBose (6/10/2009)

---

Just recently my Business Management Studio (SS 2005) has been crashing regularly. It's been flakey for months, but it's finally gotten to the point where I almost can't...

jain_abhishek (6/11/2009)

---

Hi I have a Table in 2 different databases.Table is same in schema in both databases.At any moment of time these table should have similar data.Now I come...

Yes