Month: June 2019
Populate Sage table opheadm with credit note information for Cindercone Magma to send to Tungsten/OB10
The below stored proc is used to populate two Sage fields shipper_code2 and shipper_code3 in the Order Header Table. Obiously […]
Force TSQL dateformat
If you get the following error on scheduled stored procedures, force the dateformat (The Microsoft SQL Server scheduler will probably […]
Use a case to make sure provided data is a date
I find this useful for using validating spreadsheet imports, using ISDATE can just blank the field if crap data is […]
Check the audit on Business Objects XIR3 SP7 for logons
This is useful to see who is using their licenses which are very expensive. I tend to check every few […]