Thanks JMCMULLEN,

I found out the server was not upgraded but installed with sql server 2008.

Thank you

Thanks for your reply.

But I wonder how could have the backups run on schedule before upgradation with out a job.

Thanks in advance

Thanks very much for your for the replies.

The sql server agent is running, the backups are not running on schedule.

There isn't any sql agent job setup in sql server agent...

Hello All,

I have come accross another problem and no idea how to deal.

The server is upgraded from sql server 2005 to 2008.

From the day the upgradtaion completed,

the backups of...

Thank you. That helps

Thanks for the reply.

I have tried that way already but is not working.

All I want is to select a column addressline from a table mst_address where addressline like key_word+'%'. Here...

Hi all,

Thanks for your reply.

I actually have one more query to include in the t-sql batch i posted.

and the query is

SELECT @TotalRecords = COUNT(ID) FROM @table_Results

SELECT a.Article_ID, a.ArticleType_ID, a.Source_ID,...

@jeff

yes I am all set now with the help of Gsquared post in sql server newbies - 'sql query help' topic.

I used a join on the lookup table...

Thank you very much for your reply

I am trying with something like this

this slices the right side part

update geo

set clean_addressline=

substring(addressline,len(clean_country)+1,len(addressline))

where charindex(clean_country,addressline) = 1 and cleaned_addressline is null

to slice the left side

update geo

set cleaned_addressline = substring(addressline1,0,charindex(clean_country,addressline)-1)

where charindex(clean_country,addressline1)>1...

Hello Paul,

Thanks for the reply.

insert into geo(addressline,clean_country,clean_city,clean_region,clean_postcode)

values ( '17 churchstreet 7000','Australia','Melbourne','ME','7000')

insert into geo(addressline,clean_country,clean_city,clean_region,clean_postcode)

values ('10 Downing London HA2 9DR Street','United Kingdom','London','COF','HA2 9DR')

insert into geo(addressline,clean_country,clean_city,clean_region,clean_postcode)

values('NG6 ILP Middlesex 29 Minehead Road...

Hello Gsquared,

Thanks a lot thats working.

I want to use the function because the sample table may be updated in future with new formats, so any change in the sample table should also affect the function...

Thanks for your reply. Thats working.

but when i run the query

UPDATE sample_table

SET CLEAN_POSTCODE = dbo.test(country,postcode) .

I am getting the following error

Subquery returned more than 1 value. This is not...

Thanks for that Jeff.

Is there any way of achieving something like this

If country table is inserted with a another new pattern for a country , then the function should be...