Query: Select InvoiceT total different from GLMovement total

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

Query: Select InvoiceF total different from GLMovement total

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

Query: Display SQL process (locked record)

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

Query: Update UserGroup

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

Query: Update GLMovement LineNumber

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

Queries: Issues with GLCaption

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