Just spent hours chasing down a bug

[MrMark]

hmmm bit newbie error that

would not the use of a WHERE statement solve those problems?

You fell into the trap. A bit misleading the way I put it though - it's more to do with the way different vendors treat null values.

[HairyArsedBloke]

Been going round in circles.

In the old days before senility and long term alcohol abuse I would have spotted that in seconds.

Welcome to my world.

[swamp]

I'm working on the IR35 database for HMR&C

UPDATE IT_contractors_to_investigate
SET all_tickety_boo = true
WHERE cuk_username IN ('swamp')



HTH

[EternalOptimist]

UPDATE IT_contractors_to_investigate
SET all_tickety_boo = true
WHERE cuk_username IN ('swamp')



HTH

Insert (@bargepole)
INTO Primarolo.@rsehole
where @bargepole.greasy
= true

[singhr]

A huge collective sigh of relief just went up from CUK as they realised you're doing the coding on this project

[PRC1964]

If I ever see in a SQL Statement, code to the effect of

UPDATE tableName
SET col1 = etc(@col1),
col2 = @col2,
col3 = @col3
WHERE primaryKey = primaryKey;

Both You and DP are gonna get the blame

Sadly, now that it's been posted here it will be picked up by Google and copied by thousands of spotty faced junior coders. Expect to see it turn up all over the place.

[Churchill]

That, ladies and gentlemen, is not "coding" it is SQL. An educated monkey could write it.

[sasguru]

spotty faced junior coder. .

Like AtW?

[cupidstunt]

Like AtW?

Churchill

[DimPrawn]

That, ladies and gentlemen, is not "coding" it is SQL. An educated monkey could write it.

Not one educated under New Labour.

HTH