Executing more sql commands

[wmbb]

I want to execute several sql commands after each other.

UPDATE CLIENTS SET CLIENTS.XDEPTID = 1085, CLIENTS.XDEPTNR = 88513, CLIENTS.POB = 921
WHERE (((CLIENTS.XDEPTID)=921) AND ((CLIENTS.XDEL) Is Null Or (CLIENTS.XDEL)='N'));
UPDATE CLIENTS SET CLIENTS.XDEPTID = 1086, CLIENTS.XDEPTNR = 88520, CLIENTS.POB = 894
WHERE (((CLIENTS.XDEPTID)=894) AND ((CLIENTS.XDEL) Is Null Or (CLIENTS.XDEL)='N'));

but executing this part I get an error:
[Microsoft][ODBC SQL Server Driver]Function sequence error"

I don't know much about sql but can somebody help me with this problem ?

 

[cantor001]

Maybe the removal of a few brackets might help ? Not 100% sure - because I don't know what client is being used to execute the code; this solution has not been tested.

UPDATE CLIENTS SET CLIENTS.XDEPTID = 1085, CLIENTS.XDEPTNR = 88513, CLIENTS.POB = 921 WHERE (CLIENTS.XDEPTID=921 AND (CLIENTS.XDEL Is Null Or CLIENTS.XDEL='N'));
UPDATE CLIENTS SET CLIENTS.XDEPTID = 1086, CLIENTS.XDEPTNR = 88520, CLIENTS.POB = 894
WHERE (CLIENTS.XDEPTID=894 AND (CLIENTS.XDEL Is Null Or CLIENTS.XDEL='N'));

Note that this...

(CLIENTS.XDEL Is Null Or CLIENTS.XDEL='N')

...can be reduced to...

ISNULL(CLIENTS.XDEL,'N')='N'

best wishes

 

[cantor001]

Oops, sorry, forgot which forum I was in!

Replace 'ISNULL' with 'COALESCE' in the previous post

 

[cantor001]

Please ignore my previous two posts, it's not an SQL problem and I shouldn't have treated it as such.

This question needs to be posed in some other forum, depending upon what client you are using to issue these statements against SQL Server. Once again my apologies for wasting your time.