-
I have this query that returns products that have have not been sold in 12 months:SELECT OITM.ItemCode, ItemNameFROM OITM LEFT OUTER JOIN (SELECT ItemCode FROM RDR1 WHERE DocDate > DATEADD(yy,-1,......
-
I have the following query;SELECT TOP 1T0.custmrName, T0.callID,T0.BpShipAddr, T1.Name, T0.createDate,T0.subject,T0.manufSN, T0.internalSN,T0.itemCode,T0.itemName, CAST(T0."resolution&......
-
I have this script: SELECT OITM.ItemCode, OITM.ItemName,OITM.OnHand, DATEDIFF(day, MAX(RDR1.DocDate), GETDATE()) FROM OITM JOIN RDR1 ON OITM.ItemCode = RDR1.ItemCodeWHERE OITM .......
-
This is not the browser type XSLT, this is for processing data (SAP B1 Integration Framework). Suppose we have two SQL Tables, HEADER and LINE and we want to avoid the kind of work where we first ......
-
I've used this SQL query for the SAP B1 database, that should run the different queries depends on the user's group: SELECT CASE WHEN T0.GroupId = '2' THEN( SELECT T0.......
-
I'm having trouble trying to explain my necessity, so I'll describe the scenario.Scenario:Product A has a maximum production of 125KG at a time.The operator received a production order of 1027,......
-
We are required to display UID that is in BOS_BARCODE_IT_LOG but not exists in BOS_BARCODE_DO_LOGThe reason that I joined with OITM is because the user asked for the selection Criteria in SAP ......
-
We have enabeld change tracking on some tables. Recently, we found that someone truncating the data on one table. Is it possible to prevent user truncating data on the tables which have been enabled ......
-
I am building an application using JavaFX. Application does some CRUD operations with the MySQL Database. So currently, I have 2 functions.User Registration.Email Validation (Check if email already ......
-
I have a SAP B1 installation and I have a user table consisting of WeekNo, DateFrom, DateTo ...It lists all the week numbers for each year, so the first week of the year is 202001 (yyyyww) and is set ......
-
I'm using Change Tracking in SQL Server (15) on a single table. My client application runs every x minutes and checks if the table data was changed to invalidate some cache. Within a single ......
-
I am tracking specific columns changes in table (example :tracking CustomerName, Address1 in TestCustomer Table), using Change Tracking functions in SQL Server. Everything looks good so far with ......
-
I writing a SQL server query for based on an SAP Business One DB, I have a dynamic list of columns that I am using in a PIVOT to create dynamic columns.im currently getting separate data since I pass ......
-
In our Microsoft SQL Server, the Change Tracking in each table in our database keeps going back to FALSE. We've changed it back to TRUE twice now. How come this happens and what can we do to prevent ......
-
Sometimes, when installing new vendor development, tables are added, modified, or deleted. Additionally Stored Procedures are also sometimes added, modified or deleted as well. Either of these could ......