SQLblog.net


Placeholder for procedures and whatnot.
| Comments

SSRS Report with Datasets from a Stored Procedure with Parameters, Runs Very Slowly

In most cases, SQL Server is smart enough to figure out the best execution plan for a Stored Procedure with Parameters. There are times, however, that this execution plan does not work. This was the case in an SSRS report I created which was pulling from a Stored Procedure with
Read More
| Comments

Adding DateID Using Derived Columns in (SSIS) SQL Server Integration Services

You may need to convert one or more of your date fields into an integer field. Maybe you will be using this field as a Key for your Data Warehouse DimDate field where the format would be yyyymmdd with no dashes. I will be using "Derived Columns" in SSIS to
Read More
| Comments

Deploying Reports to the (SSRS) Report Server

The first thing we need to do is find the URL location of the Reporting Server. Navigate and log in to the Reporting Services Configuration Manager. You can see that there are two URL Locations. Report Manager URL and Web Services URL. If you copy link listed under Report Manager
Read More
| Comments

Insert and Update Records with an SSIS ETL Package

Using SQL Server ETL to Insert New Records and/or Update existing records. This is the “Emp” table I created in my RunningTotals Database. I created the following fields and populated with 5 records: Next, I created an Excel Spreadsheet with a list of New Employees and a couple employees
Read More
| Comments

FileZilla FTP Server with a Windows 7 Firewall

FileZilla with a Windows 7 Firewall FileZilla Installation I love FileZilla. This is a free FTP Solution and it works beautifully and is easy to configure. Download the server version for free at https://filezilla-project.org/ to a folder on your computer. I saved mine to my SQL Folder. I
Read More
| Comments

Practice SSIS ETL Project using SQL Server 2012

This is a fun SQL Server Integration Services (SSIS) project that will help you become familiar with creating an ETL packages. ETL stands for Extract >>> Transform >>> Load. The Source File is a tab-delimited text file you should name “source.txt”. Copy/Paste the "raw" (view raw) text below into the
Read More
| Comments

SQL Server Reporting Services (SSRS) is not compatible with Internet Explorer 11

In SQL Server Reporting Services (SSRS), the toolbar that displays the report controls and export features, appears on multiple lines when viewed with Internet Explorer 11. In my search of a fix, I came across the following: https://connect.microsoft.com/SQLServer/feedback/details/810527/sql-server-reporting-services-is-not-compatible-with-internet-explorer-11 In the post I
Read More
| Comments

Top 5 Sales Reps in Each Division by Net Sales

Here are 2 t-sql queries written for SQL Server. One selects the Top 5 Sales Reps and the other Top 1 Sales Reps in each division by net sales. I am using the Running Totals database that I created in a previous blog. I create a new table RepNetSales and
Read More
| Comments

Writing a Running Totals Query

I needed to practice writing a "running totals" t-sql query with SQL Server. The first thing I did was create an example database called "Running Totals," and then a couple tables. Create the Running Totals database. Create a couple tables "Customers" with 250 rows and "Orders" with 100 randon rows
Read More
| Comments

Adding Drop-Down Parameter List in SSRS

I needed to create a Parameter that would allow me to select "Year" in a Drop-Down List using SQL Server Reporting Services. In this example we will create the Parameter in the Stored Procedure. First you must declare the Variable Then you add to the "Where" clause From the "Design"
Read More