Must declare the variable '@AppointmentsID'.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Must declare the variable '@AppointmentsID'.

Author

Topic

JeffS23
Posting Yak Master

212 Posts

Posted - 2009-08-10 : 09:44:43

I am getting this error and not sure why. Any insight is appreciated.

Msg 137, Level 15, State 2, Line 1
Must declare the variable '@AppointmentsID'.

[CODE]
SET NOCOUNT ON

CREATE TABLE #TEMP1
(
TempID INT IDENTITY ,
[1.PatientName] VARCHAR(92) ,
[2.PatLast] VARCHAR(30) ,
[3.PatFirst] VARCHAR(30) ,
[4.PatMiddle] VARCHAR(30) ,
[5.PatientAddr1] VARCHAR(50) ,
[6.PatientAddr2] VARCHAR(50) ,
[7.PatientCity] VARCHAR(30) ,
[8.PatientState] VARCHAR(3) ,
[9.PatientZip] VARCHAR(10) ,
[10.PatientCountry] VARCHAR(30) ,
[11.PatientBirthdate] DATETIME ,
[12.PatientSex] VARCHAR(1) ,
[13.PatientPhone1] VARCHAR(15) ,
[14.PatientSSN] VARCHAR(9) ,
[15.PatOccupation] VARCHAR(50) ,
[16.PatSchool] VARCHAR(30) ,
[17.PatBudget] MONEY NULL,
[18.PatientSameAsGuarantor] SMALLINT ,
[19.ReferringPhysician] VARCHAR(82) ,
[20.PatientID] VARCHAR(15) ,
[50.Department] VARCHAR(200) ,
[51.Date Of Service] DATETIME ,
[52.CPT Code] VARCHAR(10) ,
[53.Description] VARCHAR(255) ,
[54.Expiration Date] DATETIME ,
[55.Ordered By] VARCHAR(10) ,
[56.Modifier1MId] VARCHAR(255) ,
[57.Modifier2MId] VARCHAR(255) ,
[58.Modifier3MId] VARCHAR(255) ,
[59.Modifier4MId] VARCHAR(255) ,
[60.Doctor] VARCHAR(255)
)

DECLARE curAppointmentId CURSOR
FOR SELECT
AppointmentsID
FROM
Appointments
WHERE
Appointments.ApptStart >= ISNULL('07/31/2009','1/1/1900')
AND Appointments.ApptStart < dateadd(d, 1, ISNULL('07/31/2009','1/1/3000'))

DECLARE @AppointmentsID INT

OPEN curAppointmentId

FETCH NEXT FROM curAppointmentId INTO @AppointmentsID

WHILE @@FETCH_STATUS = 0
BEGIN
INSERT
#TEMP1
EXECUTE ('dbo.cusVRCSuperBillEXT @AppointmentsID')
FETCH NEXT FROM curAppointmentId INTO @AppointmentsID
END

SELECT * FROM #TEMP1

CLOSE curAppointmentId

DEALLOCATE curAppointmentId

DROP TABLE #TEMP1
[/CODE]

JeffS23
Posting Yak Master

212 Posts

Posted - 2009-08-10 : 09:53:40

Please disregard, I had to Change:

EXECUTE ('dbo.cusVRCSuperBillEXT @AppointmentsID')

To

EXECUTE dbo.cusVRCSuperBillEXT @AppointmentsID

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-10 : 13:19:28

Or use sp_executesql

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources