by SEP | Jun 15, 2020 | Query
Select * from [Forex] where convert(varchar, [DBId]) + ‘-‘ + [Reference] + ‘-‘ + convert(varchar, [Type]) + ‘-‘ + convert(varchar, [ForexId]) in (Select convert(varchar, [DBId]) + ‘-‘ + [Reference] + ‘-‘ +...
by DOS | Jun 15, 2020 | Query
Select * from [Address] where convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [CompanyId]) + ‘-‘ + convert(varchar, [PersonId]) + ‘-‘ + [Name] + ‘-‘ + convert(varchar, [AddressTypeId]) + ‘-‘ +...
by DOS | Mar 12, 2020 | Query
Delete from [CurrencyRate] where [StartDate] = EOMONTH([StartDate]) and [DBId] = 0
by DOS | Mar 12, 2020 | Query
Delete from [CurrencyRate] where not (Month([StartDate]) = 12 and Day([StartDate]) = 31) and [DBId] = 0
by DOS | Jan 2, 2020 | Query
Select * from [Group] where [Id] in (Select [GroupId] from [UserGroup] where [UserId] = 1) and substring([Rights], X, 1) = ‘1’
by DOS | Dec 22, 2019 | Query
Delete from [CurrencyRate] where Not [StartDate] in (Select Max([Startdate]) from [CurrencyRate] Group By Year([StartDate]))