Yeah that helps, how do you execute it on all instead of specifing 544?

Thanks

Ben

Hi,

I've edited my last post to try make more sense regarding setting column 1 value. Below is just one of many that look the same, it needs to check that...

Thanks for that, apologies if one of the previous posts answers my question, the value in column 1 needs to be automatically generated.

If Not Exists(Select * From group_application Where application...

Or will this work,

UPDATE Community

Set NetworkLogin = 'c' + cast(id as varchar(255))

FROM Community INNER JOIN

Constituencies ON "ID" = "ID"

WHERE ConstitCode = '@PC'

Awesome, that's great.

Can I push my luck even further...

We'd like it to update only records where a column in another table equals a particular value. For example, another table called...