WoW SQL Flashcards
The ORDER BY clause contains a column that isn’t in the SELECT clause (but is in the table targeted in the FROM clause)
Will this work?
Yes, the column does not need to be in the SELECT clause to be in the ORDER BY clause.
How would you be able to know if GP is hosted on the same server as the WoW Database?
There will be a database called DYNAMICS. A 5 character database (like ‘INTZ1’), also could be a database called TWO which is the test for GP.
WHERE clause that would match for these ProductName
Mountain-100 Silver, 38
Mountain-100 Silver, 42, Mountain-100 Black, 38, Mountain-100 Black, 42, Mountain-200 Silver, 38, Mountain-200 Silver, 42, Mountain-200 Black, 38, Mountain-200 Black, 42
but not
Mountain-200 Silver, AP, Mountain-ADC Silver, 38, Plateau-100 Black, 42
WHERE ProdcutName LIKE ‘Mountain-[0-9][0-9][0-9]%, [0-9][0-9]’
What is the WoW’s preferred policy for running queries;
Run the entire query window or highlight the query you want to run.
Always prefer to highlight just the part of the query you would like to run. Running the entire window can have unintended effects.
If one line of a PO is not complete will the other lines export?
Yes, a PO is completed line by line, and can be received upon multiple times. If one or more lines are incomplete, that doesn’t not stop the other lines from exporting, as long as the PO is open on the ERP software.
What is Microsoft Dynamics GP?
It is an enterprise resource planning (ERP) software package that uses Microsoft SQL server to store data, written in Dexterity programming language and is part of the Microsoft Dynamics suite of intelligent business applications.
What does -001 -002 etc at the end of an MO indicate?
Willow ware appends these numbers to a parent MO to indicate children MO’s for subassemblies (of the parent MO). As a point of interest, putting ‘-‘ in an MO will cause problems for WilloWare, also the product from WilloWare that creates these MO’s is called MOGen.
What is an ASN and what is it’s purpose?
Advanced Shipping Notice.
This is a document that provides detailed information about pending delivery. The purpose of which is to notify the customer when shipping occurs and provide physical characteristics about the shipment so the customer can be prepared to accept delivery.
What is WilloWare?
A business that helps it’s customers implement Dynamics GP, appears to particularly focus on customers that have specialties in manufacturing.
What is Pacejet?
Cloud-based global shipping software company
what will happen if you leave a SmartConnect map open?
That map will not run! Always close a map after you are done looking or working on it.
As a rule of thumb, what is a good way to think about how we name things?
e.g. Export, Import, Purchase/ Sales Order
We always refer to the warehouse/WoW
Exporting moves information from WoW to GP for example and importing move information into WoW. A manufcaturing order would create product within the warehoise.
What does SmartConnect do?
Moves information between WoW and other services such as GP, based upon triggers or on a regular schedule that adheres to previously established maps.
A customer has a problem that necessitates changing a stored procedure. The support representative makes the changes to the training database Sproc and confirms with the customer that this has the desired effect. These changes are then reflected in the visual studio’s customizations for that customer. [Remember, these changes have not yet been applied to production]
What is the next simplest step and why?
While, rebuilding the code would push the changes to production, this does require down time for the customer. Because this change can be applied directly to the SQL server, it can be altered while it is still running just as was done to the training database.
Which kind of join is best for these use cases:
*Creating a table of numbers, with a row for each possible value in a range.
*Generating large volumes of data for testing. When cross joined to itself, a table with as few as 100 rows can readily generate 10,000 output rows with little work from you.
CROSS JOIN
