Query: Select Company with missing LegalName

Jul 31, 2019

Select count(*) from [Company] where [LegalName] = ”

Query: Attach SQL Database

May 17, 2019

SP_CHANGE_USERS_LOGIN ‘Update_one’, ‘DeMaSy’,...

Query: Select GLAccGLCaption where the Caption and the CaptionPlan do not match

May 14, 2019

Use this query to display invalid records (SQL Server): Select * from [GLAccGLCaption] where convert(varchar, [GLAccGLCaption].[DBId]) + ‘-‘ + convert(varchar, [GLAccGLCaption].[GLAccountId]) + ‘-‘ + convert(varchar,...

Create UserOption

Apr 14, 2019

Insert Into [UserOptions] ([DBId], [UserId], [Variable], [Value]) Select -1 as [ResDBId], [User].[Id] as [ResUserId], ‘BehaviourAcctEntries’ as [ResVariable], ‘2’ as [ResValue] from [User] LEFT JOIN [UserOptions] ON ([User].[Id] =...

Query: Create SQL Database

Mar 17, 2019

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