Query: How to update a query in VersionSql table

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],...

Query: Select records with missing SecurityGLAccountId

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...

Query to delete unused Security records

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])...

Query to create Jobs based upon Job

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],...

Query to create Job Services based upon Job Service

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],...