by DOS | Sep 2, 2020 | Query
Select * from [ReminderDetail] where convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) in (Select convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) as [ResField] from [ReminderDetail] Group by [DBId], [ReminderId]...
by DOS | Aug 15, 2020 | Query
Select [InvoiceT].[Number], [invoiceT].[Date]from ((([InvoiceTDetail] LEFT JOIN [StockTransfer]ON ([InvoiceTDetail].[Id] = [StockTransfer].[InvoiceTDetailId] and [StockTransfer].[DBId] = 1))INNER JOIN [InvoiceT]ON ([InvoiceTDetail].[InvoiceTId] = [InvoiceT].[Id] and...
by SEP | Aug 14, 2020 | Query
Select * from [ReminderDetail] where convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) in (Select convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [ReminderId]) as [ResField] from [ReminderDetail] Group by [DBId], [ReminderId]...
by SEP | Jun 15, 2020 | Query
Select * from [LVATGroup] where convert(varchar, [DBId]) + ‘-‘ + [Name] in (Select convert(varchar, [DBId]) + ‘-‘ + [Name] as [ResField] from [LVATGroup] Group by [DBId], [Name] having count(*) > 1)
by SEP | Jun 15, 2020 | Query
Select * from [LVATCaseDesc] where convert(varchar, [DBId]) + ‘-‘ + [GroupName] + ‘-‘ + convert(varchar, [Ref]) + ‘-‘ + [Case] + ‘-‘ + [Description] in (Select convert(varchar, [DBId]) + ‘-‘ + [GroupName] +...
by SEP | Jun 15, 2020 | Query
Select * from [InvoiceFDetail] where convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [InvoiceFId]) + ‘-‘ + convert(varchar,[Number]) in (Select convert(varchar, [DBId]) + ‘-‘ + convert(varchar, [InvoiceFId]) + ‘-‘ +...