use [Crs#issues_20191023_issues#Inventory]

declare @schemas table (id int identity (1, 1) primary key, name varchar(100))
insert @schemas
select name from sys.schemas where name like 'Tenant_%' or name like 'Template_%' or name = 'dbo' order by DATALENGTH(name), name

delete @schemas where name = 'Tenant_11'

declare @name varchar(100) = (select top 1 name from @schemas)

while @name is not null
begin
    declare @sql nvarchar(max) = '


update ' + @name + '.StockAppendixSources
set SourceIdentifier = (
    select top 1 identifier
    from [Crs#issues_20191023_issues#Financial].' + @name + '.SalesOrders
    where id =' + @name + '.StockAppendixSources.SourceId
)
where SourceIdentifier is null and SourceId > 0 and SourceType = ''SalesOrder''


update ' + @name + '.StockAppendixSources
set SourceIdentifier = (
    select top 1 identifier
    from [Crs#issues_20191023_issues#Financial].' + @name + '.Invoices
    where id =' + @name + '.StockAppendixSources.SourceId
)
where SourceIdentifier is null and SourceId > 0 and SourceType = ''Invoice''

update ' + @name + '.StockAppendixSources
set SourceIdentifier = (
    select top 1 identifier
    from [Crs#issues_20191023_issues#Financial].' + @name + '.PurchaseInvoices
    where id =' + @name + '.StockAppendixSources.SourceId
)
where SourceIdentifier is null and SourceId > 0 and SourceType = ''PurchaseInvoice''

update ' + @name + '.StockAppendixSources
set SourceIdentifier = (
    select top 1 identifier
    from [Crs#issues_20191023_issues#Financial].' + @name + '.PurchaseDeliveries
    where id =' + @name + '.StockAppendixSources.SourceId
)
where SourceIdentifier is null and SourceId > 0 and SourceType = ''PurchaseDelivery''

update ' + @name + '.StockAppendixSources
set SourceIdentifier = (
    select top 1 identifier
    from [Crs#issues_20191023_issues#Financial].' + @name + '.GiftCards
    where id =' + @name + '.StockAppendixSources.SourceId
)
where SourceIdentifier is null and SourceId > 0 and SourceType = ''GiftCard''

update ' + @name + '.StockAppendixSources
set SourceIdentifier = (
    select top 1 identifier
    from [Crs#issues_20191023_issues#PoS].' + @name + '.Sales
    where id =' + @name + '.StockAppendixSources.SourceId
)
where SourceIdentifier is null and SourceId > 0 and SourceType = ''PosSale''

select '''+@name+''', * from ' + @name + '.StockAppendixSources
where SourceIdentifier is null
    and SourceId > 0
    and
    (
        not SourceType = ''Invoice''
        or
        (
            sourceid in (select id from [Crs#issues_20191023_issues#Financial].' + @name + '.Invoices)
            and
            sourceid not in (select id from [Crs#issues_20191023_issues#Financial].' + @name + '.Invoices where identifier is null)
        )
    )
    and
    (
        not SourceType = ''PosSale''
        or
        sourceid in (select id from [Crs#issues_20191023_issues#PoS].' + @name + '.Sales)
    )
    and
    (
        not SourceType = ''SalesOrder''
        or
        sourceid in (select id from [Crs#issues_20191023_issues#Financial].' + @name + '.SalesOrders)
    )
    and
    (
        not SourceType = ''PurchaseDelivery''
        or
        sourceid in (select id from [Crs#issues_20191023_issues#Financial].' + @name + '.PurchaseDeliveries)
    )
    and
    (
        not SourceType = ''PurchaseDelivery''
        or
        sourceid in (select id from [Crs#issues_20191023_issues#Financial].' + @name + '.PurchaseDeliveries)
    )
    and
    (
        not SourceType = ''GiftCard''
        or
        sourceid in (select id from [Crs#issues_20191023_issues#Financial].' + @name + '.GiftCards)
    )

    '
    print @sql
    exec (@sql)

    delete @schemas where name = @name
    set @name = (select top 1 name from @schemas)

end