Select [GLAccGLCaption] with doubles

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

Query: Create SQL Database

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

Query: Remove time from AccInterest.ToDate

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

Query: Select missing Language records

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