by FLO | Dec 11, 2019 | Query
SELECT [RelType].[Label], [RelType].[Type], [InvRelType].[Label] as [InvLabel], [InvRelType].[Type] From ([RelType] left Join [RelType] as InvRelType on ([RelType].[Id] = [InvRelType].[InvRelTypeId] and [InvRelType].[DBId] = @DBIdInvRelType@)) where...
by DOS | Oct 25, 2019 | Query
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...
by DOS | Oct 18, 2019 | Query
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] =...
by DOS | Jul 31, 2019 | Query
Select count(*) from [Company] where [LegalName] = ”
by DOS | May 17, 2019 | Query
SP_CHANGE_USERS_LOGIN ‘Update_one’, ‘DeMaSy’, ‘DeMaSy’
by DOS | May 14, 2019 | Query
Use this query to display invalid records (SQL Server): Select [GLAccGLCaption].* from [GLAccGLCaption] INNER JOIN [GLCaption]ON ([GLAccGLCaption].[GLCaptionId] = [GLCaption].[Id] and [GLAccGLCaption].[DBId] = [GLCaption].[DBId])where Not...