Guys,

I need to run through a simple table as follows:

userid (int) (PK)
setting (varchar(50)) (PK)
value (varchar(50))

I need to add the setting 'scentre' and value 'checked' for each distinct userid where this row doesn't already exist. I'm sure it's a really simple query but I can't for the life of me work it out