set @sqltxt = 'UPDATE commit_0 SET ledgerid = b.ledgerid FROM commit_0 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_1 SET ledgerid = b.ledgerid FROM commit_1 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_2 SET ledgerid = b.ledgerid FROM commit_2 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_3 SET ledgerid = b.ledgerid FROM commit_3 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_4 SET ledgerid = b.ledgerid FROM commit_4 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_5 SET ledgerid = b.ledgerid FROM commit_5 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_6 SET ledgerid = b.ledgerid FROM commit_6 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_7 SET ledgerid = b.ledgerid FROM commit_7 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_8 SET ledgerid = b.ledgerid FROM commit_8 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_9 SET ledgerid = b.ledgerid FROM commit_9 a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)



set @sqltxt = 'UPDATE commit_X SET ledgerid = b.ledgerid FROM commit_X a, dcasapc b,dcasledger c '
set @sqltxt = @sqltxt + 'WHERE a.ledgerid IS NULL and b.ledgerid=c.ledgerid and a.apc = b.apc and a.fy=c.fy AND a.asn=c.asn '
if (@apclist <> '')
	set @sqltxt = @sqltxt + 'and a.apc in (' + @apclist + ') '
execute (@sqltxt)