Query Select GLYEBalance records with incorrect Period

Select * from [ReminderDetail] where convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) in (Select convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) as [ResField] from [ReminderDetail] Group by [DBId], [ReminderId]...

Query ReminderDetail LPrimaryKey

Select * from [ReminderDetail] where convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) in (Select convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) as [ResField] from [ReminderDetail] Group by [DBId], [ReminderId]...

Query LVATGroup LPrimaryKey

Select * from [LVATGroup] where convert(varchar, [DBId]) + ‘-‘ + [Name] in (Select convert(varchar, [DBId]) + ‘-‘ + [Name] as [ResField] from [LVATGroup] Group by [DBId], [Name] having count(*) > 1)

Query LVATCaseDesc LPrimaryKey

Select * from [LVATCaseDesc] where convert(varchar, [DBId]) + ‘-‘ + [GroupName] + ‘-‘ + convert(varchar, [Ref]) + ‘-‘ + [Case] + ‘-‘ + [Description] in (Select convert(varchar, [DBId]) + ‘-‘ + [GroupName] +...

Query InvoiceFDetail LPrimaryKey

Select * from [InvoiceFDetail] where convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [InvoiceFId]) + ‘-‘ + convert(varchar,[Number]) in (Select convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [InvoiceFId]) + ‘-‘ +...