This is resolved. Thanks.

Perfect. It works for me. Thanks

If is about Processed = Yes or No in the first case statement then OK but has no bearing on the technique, right?

I cannot see where the missing...

Thanks. I made a change to the syntax and the Jobno was not retrieved:

Update B

set B.[Processed] =

case when (T.[XMLResponse].exist('/Boot/ErrorDetails')=1)

Then 'YES'

else 'NO'

End,

TB.[Jobno] =

case when (T.[XMLResponse].exist('/Boot/ErrorDetails')=0)

Then T.[XMLResponse].value('(/Boot/Jobs/Job_entered/@Jobno[1]','varchar(255)')

End

from Table_B T inner join Table_A...

Thanks. The Table_B with the XML is a Temporary table that has the results of some data processing; so is a form of a staging table.

The idea is that after...

Though it did not solve the problem but it helps. This was a typo from me.

The issue is i am trying to update a couple of rows in a join...

Sorry and i thank you very much.

I was using windows account before and it failed to run under that context.

I have created a SQL server account and that works.

interestingly...

It is in a mixed mode (SQLserver and Windows Authentication mode)

Thank you for having a look at this for me. The problem is still occuring.

Thank you. The Browser service is running as started and on automatic on remote server called Server1. I have changed the name to just server1 but i get the below...

Sorry i pasted the wrong info earlier on. This is the right information used to create the Linked server that failed:

USE [master]

GO

EXEC master.dbo.sp_addlinkedserver @server = N'SERVER1\MSSQLSERVER', @srvproduct=N'SQL Server'

GO

EXEC...

USE [master]

GO

EXEC master.dbo.sp_addlinkedserver @server = N'SERVER1\MSSQLSERVER', @srvproduct=N'SQL Server'

...

.....

GO

USE [master]

GO

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'SERVER1\MSSQLSERVER', @locallogin = NULL , @useself = N'False', @rmtuser = N'admin.fraka', @rmtpassword = N'xxxxxxxx'

GO

is this helpful?

not sure if sql 2000, a legacy database can do this. I will have a look.

Thank you for reply. But

if the address 1 column of the table has [8 jumbo square] but user wants [8 Park View] then Left(@address1,1) will pick both [8 Jumbo Square]...

Thank you for the response.

I forgot to add this specific:

I need the XML declaration on top of XML String as well.

I also want to leave out the element NewParameter for...

Thank you it works but how do i include the

<?xml version="1.0" ?>

so that i can pass this on as a XML parameter to a stored procedure.

I appreciate your help...