SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I was recently asked to provide a real-world example of the Linear Gauge Control. After doing a little reading and testing of the linear control I chose my path. I started with the following report: The data in the report can be reproduced using the stored procedure provided at the end of the posting. As you can see the report contains Sales data from each country. Looking...
Read More
A new feature of SQL Server 2008 is Table-valued parameters (TVP). This feature will allow Developers and DBAs to pass tables as parameters to stored procedures. You cannot pass a variable table or temp table, you can only pass a Table Type, which is an alias data type or a user-defined type. So how do you use it? The first step is to create a Table Type. See the following script: USE AdventureWorks2008 GO IF EXISTS ( SELECT * FROM sys . types WHERE name = 'CountryCodes' AND schema_id = SCHEMA_I...