by SEP | Feb 22, 2022 | Query
Select [ResInvoiceT].[DBId], [ResInvoiceT].[Number], [ResInvoiceT].[Id], [ResInvoiceT].[Type], [ResGLMovement].*, [ResInvoiceT].[Total] from (Select [GLMovement].[DBId], [GLMovement].[GLPeriodId], [GLMovement].[EntryNumber], [GLMovement].[InvoiceTId], Sum(Round(Case...
by SEP | Feb 22, 2022 | Query
Select [ResInvoiceF].[DBId], [ResInvoiceF].[Number], [ResInvoiceF].[Id], [ResInvoiceF].[Type], [ResGLMovement].*, [ResInvoiceF].[Total] from (Select [GLMovement].[DBId], [GLMovement].[GLPeriodId], [GLMovement].[EntryNumber], [GLMovement].[InvoiceFId], Sum(Round(Case...
by DOS | Sep 23, 2021 | Query
SELECTdb_name(rsc_dbid) AS ‘DATABASE_NAME’,case rsc_type when 1 then ‘null’when 2 then ‘DATABASE’WHEN 3 THEN ‘FILE’WHEN 4 THEN ‘INDEX’WHEN 5 THEN ‘TABLE’WHEN 6 THEN ‘PAGE’WHEN 7 THEN...
by FLO | Jul 27, 2021 | Query
Update UserGroup from Group after activation of the new rights Update [UserGroup] Set [UserGroup].[Type] = [Group].[Type], [UserGroup].[DBGroupId] = [Group].[DBGroupId], [UserGroup].[DBId] = [Group].[DBId]From [UserGroup] Inner join [Group] On [UserGroup].[GroupId] =...
by DOS | May 4, 2021 | Query
ALTER TABLE GLMovement ADD Id INT IDENTITY(1,1) Update [GLMovement] Set [LineNumber] = [ResGLMovement].[ResLineNumber]from (Select [DBId] as [ResDBId], [Id] as [ResId], ROW_NUMBER() OVER(ORDER BY [GLMovement].[LineNumber]) as [ResLineNumber] from [GLMovement] where...
by DOS | Apr 28, 2021 | Query
Queries Query: Select GLAccGLCaption with invalid TableName Query: Select GLAccGLCaption with missing GLCaptionPlan Query: Select GLAccGLCaption with doubles Query: Select GLAccGLCaption where the Caption and the CaptionPlan do not match Query: Select GLAccGLCaption...