by Administrator | Mar 28, 2019 | Query
Select * from [GLAccGLCaption] INNER JOIN ( Select [DBId], [GLAccountId], [TableName], [TableId], [GLCaptionPlanId] from [GLAccGLCaption] where Not [GLCaptionId] = 0 Group by [DBId], [GLAccountId], [TableName], [TableId], [GLCaptionPlanId] having count(*) > 1 ) as...
by DOS | Mar 17, 2019 | Query
DROP LOGIN DeMaSy;CREATE LOGIN [DeMaSy] WITH PASSWORD = ‘demasy’, DEFAULT_LANGUAGE = [French],CHECK_POLICY = OFF; Create Database Licence COLLATE SQL_Latin1_General_CP1_CI_AS; Alter Database Licence Set AUTO_SHRINK ON; Use Licence; CREATE SCHEMA DeMaSy;...
by Administrator | Mar 5, 2019 | Non classé, Query
Select * from [GLAccGLCaption] where Not [TableName] in (‘(None)’, ‘ClientType’, ‘SupplierType’) Select [DBId], [GLAccountId], [TableId], [GLCaptionPlanId], [GLCaptionId], [DGLCaptionId], [CGLCaptionId] from [GLAccGLCaption] Group...
by Frédéric Lamain | Feb 27, 2019 | Query
Select * from [TimeReport] where [TimeReport].[JobTaskId] = -1 Order by [TimeReport].[Id]
by Administrator | Feb 22, 2019 | Query
Use this query to update incorrect records (SQL Query): Select * from [AccInterest] where Not Convert(date, [ToDate]) = [ToDate] Update [AccInterest] Set [ToDate] = convert(date, [ToDate]) where Not Convert(date, [ToDate]) = [ToDate] Use this query to select incorrect...
by Administrator | Jan 18, 2019 | Query
Preview in new tab(opens in a new tab) Use this queries to display invalid records (SQL Query): Select [Licence].[DeMaSy].[DBList].[DBId], count(*) from [Licence].[DeMaSy].[DBList] left join [DeMaSy].[DeMaSy].[Language] on [Licence].[DeMaSy].[DBList].[DBId] =...