Passing Table Valued Parameters from Reporting Services to Stored Procedures

Warning: This solution only works with SQL Server 2008 Step 1. Create a Table Type The Table type will hold the values from your multi-value parameters list. Code Example: CREATE TYPE [dbo].[CustomerTableType] AS TABLE( [PARAM] [int] NULL, [RunningId] [int] IDENTITY(1,1) NOT NULL, CHECK (([RunningId]<(10000))) ) Note: if you want a generic table type you can change the name to IntTableType, GUIDTableType, or VarcharTableType or whatever makes s... [More]

Posted by: adamwright
Posted on: 8/2/2009 at 6:11 AM
Tags: , ,
Categories: SQL Server 2008 | SSRS
Actions: Bookmark and Share
Post Information: Permalink | Comments (0) | Post RSSRSS comment feed

Installing and Configuring BlogEngine.NET 1.5 using SQL Server 2005

How to install Blog Engine.NET using Microsoft SQL Server as the back end database for the application and the membership provider. [More]

Posted by: AdamWright
Posted on: 8/1/2009 at 7:56 AM
Tags: ,
Categories: BlogEngine.NET
Actions: Bookmark and Share
Post Information: Permalink | Comments (0) | Post RSSRSS comment feed

Welcome To AdamJWright.com

Thank you to anyone who decided to visit my site.  This is my first post, and I promise I will add a new post in the very near future discussing how to setup blogengine .NET 1.5 because it was not as easy as I would have expected.  Mosts new articles will be either related to C# .NET coding or SQL Server.   I may add more sections in the future for other non-topic specific content. Leave a comment if you would like, and I'll get back with you soon. Again thanks for visiting. ... [More]

Posted by: AdamWright
Posted on: 7/30/2009 at 5:50 PM
Actions: Bookmark and Share
Post Information: Permalink | Comments (1) | Post RSSRSS comment feed