Query: Select Companies having double VAT Numbers

Oct 25, 2019

Select Replace([IBLCNum],’ ‘, ”), [Name] from [Company] where [DBId] = 3 and Replace([IBLCNum],’ ‘, ”) in (Select Replace([IBLCNum],’ ‘, ”) from [Company] where not [IBLCNum] = ” and [DBId] = 3Group by...

Query: Select Countries and Translations

Oct 18, 2019

SELECT [Country].[Name], [Language].[Name], CountryName.Name, CountryName.Nationality from (([Country] Left Join [CountryName] ON ([Country].[Id] = [CountryName].[CountryId] and [CountryName].[DBId] = 0)) LEFT JOIN [Language] ON ([CountryName].[LanguageId] =...

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