Check Netsuite Link Server Connection

Check Netsuite Link Server Connection

Netsuite error: Cannot fetch a row from OLE DB provider “MSDASQL” for linked server. Say you have sql job calling a stored procedure on a local SQL server that is pulling data from NS scheduled at 8pm daily.  It’s been running fine for a...
How to Set a Date Range

How to Set a Date Range

Say you need a date range on gathering data for a report starting from Friday to Thursday based on the current date. Example dates July 5 to 11, July 12 to 18, July 19 to 25 and July 26 to Aug 1. So for July 5 to 11, you want the report to run this range of dates if...
Create Sequence # for Each Invoice # in sql

Create Sequence # for Each Invoice # in sql

Here’s a good trick to create a line sequence number for each invoice # that I found on the internet which help me on one of my projects. First create a table.  The seq column is used as the seed in building the sequence number for each invoice # line sequence number...
Wait! Before You GoWould you like to talk to a business software expert to answer your questions?

When you schedule a free consultation with MIBAR, you will experience a one-on-one conversation with a business technology expert who is passionate about understanding your unique needs or issues. Schedule a free consultation today at the link below or give us a call at (212) 869-9300.

Learn More