...
Run the following script against your company's database Microsoft SQL Server Management Studio to obtain a count of employees, activities, cost code labor, cost code expense, pay code labor, pay code expense, and equipment. This will provide an overview of how much data you will be uploading to the Journyx cloud.
| Note | ||||||||
|---|---|---|---|---|---|---|---|---|
|
SELECT
(SELECT COUNT(*) FROM jxEmployee) AS EmployeeCount,
(SELECT COUNT(*) FROM jxJobServiceCall) AS ActivityCount,
(SELECT COUNT(*) FROM jxCostCodeLabor) AS CostCodeLaborCount,
(SELECT COUNT(*) FROM jxCostCodeExpense) AS CostCodeExpenseCount,
(SELECT COUNT(*) FROM jxPayCodeLabor) AS PayCodeLaborCount,
(SELECT COUNT(*) FROM jxPayCodeExpense) AS PayCodeExpenseCount,
(SELECT COUNT(*) FROM jxEquipmentGLAccount) AS EquipmentCount
...