pjandshelly
Board Regular
- Joined
- Jan 25, 2017
- Messages
- 61
I am using a SQL Query with Parameters that I have connected to an excel document. I am getting an error when running the data query of:
[Microsoft][ODBC SQL Server Driver]Invalid Parameter Number. I have been able to get this report to run in the past, but having an issue now.
Below is my query:
with tv as (
select a.AppointmentDateTime, a.DataEntryStaffSID, a.AppointmentMadeDate, a.Sta3n
from appt.appointment a
where a.sta3n = 558
and a.AppointmentDateTime >= dateadd(day,-365, getdate())
and a.AppointmentDateTime <= getdate()
and a.DataEntryStaffSID in (15590949,
1202021379,
1202309708,
1202344781,
1202408942,
1202407701,
1203335029,
1204430504,
1205076023,
1206364862,
1206364864,
1206684106,
1206792953,
1206794793,
1206820287,
1206922884,
1207111900,
1020051,
836559,
10429449,
872418,
995576,
853813)
)
select b.staffName, a.AppointmentMadeDate, a.AppointmentDateTime
from tv a
join sstaff.SStaff b on b.staffSID = a.DataEntryStaffSID
where b.sta3n = 558 and a.AppointmentMadeDate >= ?
and a.AppointmentMadeDate <= ?
order by b.staffName, a.AppointmentMadeDate
;
[Microsoft][ODBC SQL Server Driver]Invalid Parameter Number. I have been able to get this report to run in the past, but having an issue now.
Below is my query:
with tv as (
select a.AppointmentDateTime, a.DataEntryStaffSID, a.AppointmentMadeDate, a.Sta3n
from appt.appointment a
where a.sta3n = 558
and a.AppointmentDateTime >= dateadd(day,-365, getdate())
and a.AppointmentDateTime <= getdate()
and a.DataEntryStaffSID in (15590949,
1202021379,
1202309708,
1202344781,
1202408942,
1202407701,
1203335029,
1204430504,
1205076023,
1206364862,
1206364864,
1206684106,
1206792953,
1206794793,
1206820287,
1206922884,
1207111900,
1020051,
836559,
10429449,
872418,
995576,
853813)
)
select b.staffName, a.AppointmentMadeDate, a.AppointmentDateTime
from tv a
join sstaff.SStaff b on b.staffSID = a.DataEntryStaffSID
where b.sta3n = 558 and a.AppointmentMadeDate >= ?
and a.AppointmentMadeDate <= ?
order by b.staffName, a.AppointmentMadeDate
;