Thanks all for the inputs.

Found out the reason.

We have created a different service account for various applications.

And there is one service account that was used across three applications in three...

15/02/2013 04:25:57

21/02/2013 02:25:57

these are non working

Thanks Cory for all your answers.

I will start again .

I have a table which consists of the fields

Addressline1,Addressline2,Addressline3, FormattedAddress,Town,City etc.

The table (tblCustomerAddress) consists of 3 million rows approximately.

What we were...

The requirements are that I should write only an update query

and the string will consist of many words.

I am not sure about the reasons why SSIS has been ruled out,...

Thanks Cory for the reply.

There has been one more pre-requisite, I am supposed to do in an update query.

declare @data nvarchar(200)

set @data='12-12 ORANGE-RED'

select

Thanks for the reply

Yes, the field address will be exactly the same.

But sometimes it might change as below

5th Street,10th Main Road,ARY,ARYSHIRE.

Sorry forgot to mention, I will be executing the query...

Chandru, yours also works.

Thanks

Brilliant way Lynn.

It works

Ok I am providing you with sample data

Category Id CategoryName

1 Gifts

2 ...

EdVassie (6/8/2009)

---

If you are asked 'Is anyone in the office wearing a red shirt' what do you do?

a) Go round the entire office counting the number of people and making...

Thanks

After installing the problem has been solved

Many many thanks

Thanks for the prompt reply

But one question(sorry if its too silly),

should i install

SQL Server 2005 Express Edition,

or

SQL Server Management Studio Express,

Hi,

I installed the SQL Server Management Studio Express from

http://www.microsoft.com/express/sql/previous/default.aspx

I have installed that successfully.

But when I start the, I have that dialog box that asks for the Server...

Thanks Gila .Can I have a free download of Developer Edition.

And in case I have to install Developer, do I need to uninstall those mentioned in my first post

My OS--Windows xp professional

Installling --Sql server 2005 Enterprise Edition