SQLblog.net


Placeholder for procedures and whatnot.
| 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