(212)-869-9300 info@MIBAR.net
  • Support
  • Free Consultation
MIBAR
  • Services
    • ERP Software
    • CRM Software
    • Business Intelligence
    • Infrastructure
    • Mobile
    • Cloud
  • Solutions
    • NetSuite
    • Acumatica
    • Microsoft Dynamics GP
    • Microsoft Dynamics 365
    • Power BI
    • Power Platform
    • Search By Industry
    • Search By Role
  • Industries
    • Distribution
    • Manufacturing
    • Food & Beverage
    • Retail
    • Airports
    • Consumer Packaged Goods
    • Professional Services
    • Finance
    • Healthcare
    • Rights and Royalty Management
  • About
    • How We Work
    • Leadership Team
    • Testimonials
    • News
    • Careers
    • Contact
  • Resources
    • Case Studies
    • Webinars
    • Whitepapers
    • Blog
  • Contact
Select Page
Set Values of Every Column to the Appropriate Non-Null Default

Set Values of Every Column to the Appropriate Non-Null Default

by Craig Rubenstein | Mar 12, 2019 | How To

Ask any SQL developer to tell you about what is more exasperating than having to account for dividing by zero and they’ll probably say the word “null”.  Dividing by zero can be handled with a simple CASE statement, but unless you’re calculating gross profit % on an...
Error While Restore SQL 2008 Dynamics GP Database From Backup

Error While Restore SQL 2008 Dynamics GP Database From Backup

by Eusebe Yode | Mar 1, 2019 | How To

When performing a full restore over an existing database, SQL Backup sometimes reports that the database cannot be restored because it is currently in use. This error shows not only during restore backup, but also for drop database or alter database as well. In this...
Convert a Narrow Table Data to a Wide Table Data Dynamically in SQL

Convert a Narrow Table Data to a Wide Table Data Dynamically in SQL

by William Tom | Feb 1, 2019 | How To

Reading a narrow pivot table to create a new wide dynamic pivot table using the values from a field of narrow table in sql server. (SQL Server skill level: Advanced/Expert) Example: Narrow table. Docnum           description       amt 100                 ...

How to Handle a NULL Value Loaded by SSIS From a CSV File

by William Tom | Apr 3, 2017 | How To

In this tutorial, I will show how to handle a NULL value loaded by SSIS from a CSV file. Note that some knowledge of Excel, SQL and programming is necessary. 1.  Build a CSV file. Here’s a sample file: 2.  Create a table in the SQL server database: create table...

Using SQL Views for Development and Analysis

by Craig Rubenstein | Jan 6, 2017 | Microsoft Dynamics GP

Happy New Year!  If your resolution is to improve your business intelligence capabilities and get about how you’re leveraging your data, you’ve come to the right place.  Whether you’re a developer or end-user, SQL views can be a convenient and powerful...
« Older Entries

Get the Latests News to Your Inbox

Click here to register for our newsletter.

Resources:

  • – True Cloud vs. Fake Cloud: How to Identify and Understand the Differences in Cloud Software
  • – 5 Key Considerations When Implementing a Modern BI
  • – Enabling the Modern Business Through IT
  • – Business Intelligence Made Easy—Power BI Case Study

Categories

  • Accounting/Finance
  • Acumatica
  • Airport
  • Artificial Intelligence (AI)
  • Blockchain
  • Cloud
  • Data Migration
  • Digital Transformation
  • Distribution
  • Dynamics 365
  • Ecommerce
  • ERP Implementation
  • Food and Beverage
  • How To
  • Inventory Management
  • Manufacturing
  • Meet MIBAR
  • Microsoft Dynamics CRM
  • Microsoft Dynamics GP
  • Microsoft Teams
  • Microsoft Windows
  • NetSuite
  • Opinion
  • Power BI
  • Power Platform
  • Process
  • Project Management
  • Recovery
  • Security
  • SEO
  • Supply Chain
  • Technology
  • Terminal Management
  • Warehouse Management
  • Webinar

About MIBAR

MIBAR.net is a leading implementation partner and application consultant for the NetSuite, Acumatica, Dynamics 365, Microsoft Power BI, and Microsoft Dynamics GP platforms.

Since 1991, we have implemented ERP, CRM, BI, mobile, and eCommerce solutions for mid-market businesses across the United States.

Contact Information

1001 Avenue of Americas
Suite 1507
New York, NY 10018

Toll Free: 800-MIBAR-4-U
Phone: 212-869-9300
Fax: 212-869-9350
E-Mail: info@MIBAR.net

Quick Links

Solutions

Services

Case Studies

Webinars

Client Support

  • LinkedIn
  • YouTube
  • Facebook
  • Twitter
© 2023 R and S Computers Inc. All Rights Reserved. Privacy Policy