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...
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...
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 ...
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...
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...
