GitHub - theusual/sql-scripts-macola-wisys-epicor: A backup repository of my SQL scripts used both inside and outside of the workplace including: -Helpful DBA scripts -Macola Progression scripts -Macola ES scripts -Wisys scripts -Brysys scripts -Epicor scripts

theusual / sql-scripts-macola-wisys-epicor Public

Notifications You must be signed in to change notification settings
Fork 11
Star 10

A backup repository of my SQL scripts used both inside and outside of the workplace including: -Helpful DBA scripts -Macola Progression scripts -Macola ES scripts -Wisys scripts -Brysys scripts -Epicor scripts

10 stars 11 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 20 Commits
Brysys-Infiniti		Brysys-Infiniti
Brysys-MacolaObjects		Brysys-MacolaObjects
Brysys-Marco		Brysys-Marco
Brysys-RemisUSA		Brysys-RemisUSA
DBA Scripts		DBA Scripts
EDI		EDI
Epicor-RemisUSA		Epicor-RemisUSA
Epicor		Epicor
Macola-RemisUSA		Macola-RemisUSA
MacolaES		MacolaES
PerformanceTuning		PerformanceTuning
Pulse-WalMartTrackingSystem		Pulse-WalMartTrackingSystem
ScriptsForSQLJobs		ScriptsForSQLJobs
StoredProcedures		StoredProcedures
Triggers		Triggers
Wisys		Wisys
10-5-11.sql		10-5-11.sql
10-8-11.sql		10-8-11.sql
AA-EDIProblems.sql		AA-EDIProblems.sql
AP&PO Query - Vouchers + PO Info.sql		AP&PO Query - Vouchers + PO Info.sql
AP-AR-FixDuplicateEntriesOnVendorOrCustomerCard.sql		AP-AR-FixDuplicateEntriesOnVendorOrCustomerCard.sql
AP-Item-Report.sql		AP-Item-Report.sql
AP-View-VendorCard-Card.sql		AP-View-VendorCard-Card.sql
AP-View-VendorCard-ShowsVouchersEtc.sql		AP-View-VendorCard-ShowsVouchersEtc.sql
APItemChecklistSSRS.sql		APItemChecklistSSRS.sql
AP_Card_Payables.sql		AP_Card_Payables.sql
AR-CustomerCard-Card-View.sql		AR-CustomerCard-Card-View.sql
AR-CustomerCard-Receivables-View.sql		AR-CustomerCard-Receivables-View.sql
ARS.sql		ARS.sql
ARSHTFIL Trigger For Wisys Shipping Data - DELETE.sql		ARSHTFIL Trigger For Wisys Shipping Data - DELETE.sql
ARSHTFIL Trigger For Wisys Shipping Data.sql		ARSHTFIL Trigger For Wisys Shipping Data.sql
ARSHTTBL_MOVE_SHIPPING_RECORDS.sql		ARSHTTBL_MOVE_SHIPPING_RECORDS.sql
Accounting Tables List.sql		Accounting Tables List.sql
Agility-Kitting.sql		Agility-Kitting.sql
AiefeiPricingAnalysis-POHistory-2.sql		AiefeiPricingAnalysis-POHistory-2.sql
AiefeiPricingAnalysis-POHistory.sql		AiefeiPricingAnalysis-POHistory.sql
AvgLeadTimeForAifeiWood.sql		AvgLeadTimeForAifeiWood.sql
AvgLeadTimeForCHVendors.sql		AvgLeadTimeForCHVendors.sql
BACKUP DB SCRIPT.sql		BACKUP DB SCRIPT.sql
BACKUP-RestoreRecordsIntoGBKMUTandBANKTRANSACTIONSfromBackupTables.sql		BACKUP-RestoreRecordsIntoGBKMUTandBANKTRANSACTIONSfromBackupTables.sql
BG_BankTransactions.sql		BG_BankTransactions.sql
BG_amutak.sql		BG_amutak.sql
BG_gbkmut.sql		BG_gbkmut.sql
BOMSsearch.sql		BOMSsearch.sql
Backorder flag.sql		Backorder flag.sql
Backorders&Split Ships.sql		Backorders&Split Ships.sql
Basic Updating Template.sql		Basic Updating Template.sql
BasicItemView-WithParentFlag.sql		BasicItemView-WithParentFlag.sql
BiWeeklyReport-WeightsMissing.sql		BiWeeklyReport-WeightsMissing.sql
BigReport-Z_China_Ops.sql		BigReport-Z_China_Ops.sql
BumperSalesReport.sql		BumperSalesReport.sql
CH Order Report 3-5-2012.sql		CH Order Report 3-5-2012.sql
CH Order Report 3-6-2012 - New Version With CH Vendor # Only.sql		CH Order Report 3-6-2012 - New Version With CH Vendor # Only.sql
CH Order Report-view-NC Only.sql		CH Order Report-view-NC Only.sql
CH Order Report-view.sql		CH Order Report-view.sql
CH Order Report.sql		CH Order Report.sql
CH Ordering Report - CAN Version.sql		CH Ordering Report - CAN Version.sql
CH Ordering Report 6-6-11.sql		CH Ordering Report 6-6-11.sql
CH Ordering Report 7-18-11.sql		CH Ordering Report 7-18-11.sql
CH VENDOR DATE DIFF FOR EMAIL.sql		CH VENDOR DATE DIFF FOR EMAIL.sql
CH Vendor Report - By Prod Cat.sql		CH Vendor Report - By Prod Cat.sql
CH Vendor Report.sql		CH Vendor Report.sql
CH-Inv-Analysis.sql		CH-Inv-Analysis.sql
CHOrderReportView.sql		CHOrderReportView.sql
CalcSalesAmount.sql		CalcSalesAmount.sql
CheckBOLShipViaCodes.sql		CheckBOLShipViaCodes.sql
CheckUserDefFld4.sql		CheckUserDefFld4.sql
China Vendor Email.sql		China Vendor Email.sql
ChinaAP&ARReports.sql		ChinaAP&ARReports.sql
ChinaInvProjections-COMPONENTS.sql		ChinaInvProjections-COMPONENTS.sql
ChinaInvProjections.sql		ChinaInvProjections.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-17-12-OLD VERSION-SPLIT SALES QUERY.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-17-12-OLD VERSION-SPLIT SALES QUERY.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-17-12.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-17-12.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-22-12-OLD VERSION-1 SALES QUERY.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-22-12-OLD VERSION-1 SALES QUERY.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-24-12-NoProjectionSalesOrders.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-24-12-NoProjectionSalesOrders.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-28-12-ALLPurchasedItems.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-28-12-ALLPurchasedItems.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-28-12-CHitems-SalesProjExcluded.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-28-12-CHitems-SalesProjExcluded.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-28-12-CHitems-SalesProjIncluded.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-2-28-12-CHitems-SalesProjIncluded.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-CHitems-SalesProjExcluded.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-CHitems-SalesProjExcluded.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-CHitems-SalesProjIncluded.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-CHitems-SalesProjIncluded.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-CaseRefurb.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-CaseRefurb.sql
ChinaInventoryProjectionsReport(HolyGrail)-Revised-InternationalItems.sql		ChinaInventoryProjectionsReport(HolyGrail)-Revised-InternationalItems.sql
ChinaLanguageTests.sql		ChinaLanguageTests.sql
Compare List Prices To Selling Prices.sql		Compare List Prices To Selling Prices.sql
ConfirmShipJobTroubleshooting.sql		ConfirmShipJobTroubleshooting.sql
ConfirmShippingCheck.sql		ConfirmShippingCheck.sql
ContractComparisonQuery-ByItem-2011.sql		ContractComparisonQuery-ByItem-2011.sql
ContractComparisonQuery-ByItem.sql		ContractComparisonQuery-ByItem.sql
ContractComparisonQuery-POTotalsView.sql		ContractComparisonQuery-POTotalsView.sql
ContractComparisonQuery.sql		ContractComparisonQuery.sql
CopyAllEDITables.sql		CopyAllEDITables.sql
CountMacolaUsers.sql		CountMacolaUsers.sql
Create To ARSHTTBL.sql		Create To ARSHTTBL.sql
Credits Script.sql		Credits Script.sql
CurrentQueries-11-5-13.sql		CurrentQueries-11-5-13.sql
CurrentQuery-6-31.sql		CurrentQuery-6-31.sql
CustomersBySales.sql		CustomersBySales.sql
DB-HighestRowCount.sql		DB-HighestRowCount.sql
DBA-AlterDBToSingleUser.sql		DBA-AlterDBToSingleUser.sql
DBA-KillAllUserConnectionsToDB-AllSPIDs.sql		DBA-KillAllUserConnectionsToDB-AllSPIDs.sql