by Administrator | Apr 28, 2021 | Query
Select * from [GLAccGLCaption] LEFT JOIN [ClientType] ON ([GLAccGLCaption].[TableId] = [ClientType].[Id] and [GLAccGLCaption].[DBId] = [ClientType].[DBId]) where [GLAccGLCaption].[TableName] = ‘ClientType’ and [ClientType].[Id] Is Null Select * from...
by Administrator | Apr 28, 2021 | Query
Select * from [GLAccGLCaption] LEFT JOIN [SupplierType] ON ([GLAccGLCaption].[TableId] = [SupplierType].[Id] and [GLAccGLCaption].[DBId] = [SupplierType].[DBId]) where [GLAccGLCaption].[TableName] = ‘SupplierType’ and [SupplierType].[Id] Is Null Select *...
by Administrator | Feb 8, 2021 | Query
Select [GLMovement].[DBId] as [ResDBId], [GLMovement].[GLPeriodId] as [ResGLPeriodId], [GLMovement].[GLAccountId] as [ResGLAccountId], [GLMovement].[CurrencyId] as [ResCurrencyId], Round(Sum(Case When [GLMovement].[CD] = ‘D’ Then [GLMovement].[Amount] Else...
by Administrator | Feb 3, 2021 | Query
Select * from [Options] where convert(varchar, [Options].[DBId]) + ‘-‘ + [Options].[Variable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + [Options].[OrgTable] + ‘-‘ + convert(varchar, [Options].[FieldId]) in (Select...
by Administrator | Nov 29, 2020 | Query
Select [GLAccount].[DBId], [GLAccount].[Number] + ‘, ‘ + [GLAccount].[Name], count([GLMovement].[EntryNumber]) from [GLMovement] INNER JOIN [GLAccount] On ([GLMovement].[GLAccountId] = [GLAccount].[Id] and [GLMovement].[DBId] = [GLAccount].[DBId]) where...
by DOS | Nov 3, 2020 | Query
Select * from (Select [DBId], [Id], [Label], [Inverselabel] from [RelationType]) as [Res1] INNER JOIN (Select [DBId], [Id], [Label], [Inverselabel] from [RelationType]) as [Res2] ON ([Res1].[DBId] = [Res2].[DBId] and [Res1].[Label] = [Res2].[Inverselabel] and Not...