I have written a stored procedure inside of SQL Server 2008. When I attempt to execute the stored procedure, I get the following error: Msg 137, Level 15, State 2, Line 1 Must declare the scalar variable "@Year". I've included the code for the stored procedure. Code Snippet: 1: 2: 3: 4...

Hi, I'm very new to VB and Visual Studio but I know what I want to acheive and have already written the underlying SQL Stored Procedure and the Crystal Report to produce the output reports required by my company. Just need to make a user friendly program to run it. What I'm trying to do is this...

Brainiacs, Techies and Wizards-- I am trying to convert a List object passed as a parameter to a wcf method call to an XmlDocument which I can pass on to an existing stored procedure. Here is the code snippet for the working stored proc: ALTER PROCEDURE [dbo].[InsertOrder] ( @UserID varchar(40), @LocID...