I have a stored procedure that was previously working but has since stopped since I imported date into the table that it should be altering.
The purpose of this stored proc is to take new patient data input by user and add data to new record in patient table and generate and output the new patients ID number. But now upon execution I recieve the error msg: Procedure or function has too many arguments specified. This is a critical and time sensitive issue so ANY assistance would be appreciated.
/****** Object: StoredProcedure [dbo].[usp_InsPatient] Script Date: 05/10/2011 10:16:43 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
-- Batch submitted through debugger: SQLQuery13.sql|7|0|C:\Users\Administrator\AppData\Local\Temp\1\~vsC167.sql
ALTER PROCEDURE [dbo].[usp_InsPatient]
@PatientID int output
--@err varchar(250) = null output
-- usp_InsPat 'test','ltest',null,null,null,null,'10/25/2010'
declare @err as varchar(100)
if @Firstname IS
View Complete Post