test please delete

[zeitghost]

Warm out there again...

Not half as warm as it is in here.

It's cooled down to a balmy 26 deg C in my office now all the doors & windoze are open.

[NickFitz]

Morning denizens

Started out a bit cloudy, but it's turning sunny out there now

The cooker will be arriving around lunchtime, if the estimates are correct.

[MrMarkyMark]

Unplanned day off

They have removed my remote access that I had reapplied just last week .

That means more days at Client Co sorting it out

Still lovely day, so mustn't complain

[SueEllen]

Tired.

No meetings today as off-shore are all off

So will be writing documentation and doing other boring stuff.

[eek]

hunting for a means of identifying 9000 records that look identical to the other 450,000 but aren't really...

[eek]

Just asked an agent on linked regarding what is clearly a contract or 2 in DWP whether its government work, and what framework and whether the ESS tool has generated a response regarding inside or outside IR35. lets see if I get a response...

[NickFitz]

Links are up - thought I'd better post them now, as the cooker is due to arrive in an hour or so, so I'll be ditzing around with that

[WTFH]

hunting for a means of identifying 9000 records that look identical to the other 450,000 but aren't really...

In what way are they not identical?
There must be some way - perhaps a field is null when it should be blank, or by user id, date/time, etc


Even if you can just narrow it down. I had one last week where under certain circumstances an old record was being updated even after it was closed and that was creating duplicates in another table, it was 200 out of 42,000 records.
Got the list down to about 800 records by looking for things that were the same across some fields, then had to do the final checks in Excel but 800 was easier to check that 42k.

[NickFitz]

The delivery van is now on my road!

That doesn't mean very much, as it's a long road - it runs from Exeter to Lincoln in a nearly straight line

But it's on this stretch of the road now. It's still got four other deliveries to make before it gets here, though

[eek]

In what way are they not identical?
There must be some way - perhaps a field is null when it should be blank, or by user id, date/time, etc


Even if you can just narrow it down. I had one last week where under certain circumstances an old record was being updated even after it was closed and that was creating duplicates in another table, it was 200 out of 42,000 records.
Got the list down to about 800 records by looking for things that were the same across some fields, then had to do the final checks in Excel but 800 was easier to check that 42k.

The thing is that they should look very different and have whopping large amounts of empty fields (some explicitly so) and they don't

I strongly suspect that they haven't sent me the correct data set but I'm not calling them up on it until I have evidence (it means the entire project will be pushed back a fortnight)..