update settings 
set value = (select top 1 submissionnumber from ediclaimfile where ediclaimfile.clearinghouseid = settings.clearinghouseid and ediclaimfile.pluginid=settings.pluginid order by submissionnumber desc)
from settings
join clearinghouse cl on settings.clearinghouseid = cl.clearinghouseid
join ediclaimfile edi on cl.clearinghouseid = edi.clearinghouseid
join plugin pu on edi.pluginid=pu.pluginid
where settings.type = 'ClearinghouseClaimsEligibilityCreation' and settings.name='submissionnumber'

update settings 
set value = '75000'
where settings.type = 'ClearinghouseClaimsEligibilityCreation' and settings.name='submissionnumber' and settings.value is null