by Administrator | Jan 10, 2019 | Query
Update VersionSql set Query = ‘Select [Version].[Licence], [Version].[SerialNumber], [Version].[Major], [Version].[Minor], [Version].[Other] From [Version] order by [Version].[Licence], [Version].[SerialNumber], [Version].[Major], [Version].[Minor],...
by SEP | Oct 23, 2018 | Query
Use these queries to display invalid records (SQL Query): Select distinct [ArtDepPayment].[DBId] from [ArtDepPayment] where ([SecurityGLAccountId] = 0 or [SecurityGLAccountId] is null) and not [ArticleId] = 0 and not [ArticleId] is null Union Select distinct...
by FLO | Jun 26, 2018 | Query
Use this query to select unbalanced accounting entries on all the databases: Select [DBList].[LogicalName], [DBList].[DBId], [GLPeriod].[Name], [GLMovement].[EntryNumber] From ([GLMovement] INNER JOIN [GLPeriod] ON ([GLMovement].[GLPeriodId] = [GLPeriod].[Id] and...
by Administrator | Apr 16, 2018 | Query
Use this query to delete unused Security records: Delete from [Article] where convert(varchar, [Article].[DBId]) + ‘-‘ + convert(varchar, [Article].[Id]) in (Select convert(varchar, [Article].[DBId]) + ‘-‘ + convert(varchar, [Article].[Id])...
by Administrator | Feb 23, 2018 | Query
Use this query to create Jobs based upon a single Job: Insert Into [Job] ([DBId], [Id], [Number], [ClientId], [JobTypeId], [DivisionId], [Description], [Actif], [Archive], [JobServiceTRRestriction], [StartDate], [EndDate], [Chargeable], [Status], [TRLockType],...
by Administrator | Feb 23, 2018 | Query
Use this query to create Job Services based upon a single Job Service: Insert Into [JobService] ([DBId], [Id], [JobId], [ServiceId], [Num], [Description], [DescriptionExcess], [ClientId], [FeeType], [FeeTypeTrigger], [Fees], [ACFees], [Limit], [IndexValue],...