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