'int' is not a recognized CURSOR option.

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

General SQL Server Forums

New to SQL Server Programming

'int' is not a recognized CURSOR option.

Author

Topic

TestEngineer
Starting Member

29 Posts

Posted - 2006-02-17 : 14:25:33

'int' is not a recognized CURSOR option.

I think this error message is related to the fact that I'm using CREATE Table in my stored procedure to handle temporary table data. What can I do to declare a variable here?

CREATE PROCEDURE spTeamPORReport
(@FacilityName nvarchar(50) = NULL,
@CustomerTeamName nvarchar(50) = NULL,
@CustomerName nvarchar(50)=NULL,
@AssemblyPartNumber nvarchar(50)=NULL,
@DateStart smalldatetime,
@DateEnd smalldatetime)
AS
SET NOCOUNT ON

DECLARE MyRecordCount int

CREATE TABLE #FiveWorstPerformance
(PartNumber nvarchar(50),
Customer nvarchar(50),
ProdDesc nvarchar(50),
TestedICT bigint,
FailedICT bigint,
FPYICT float,
TestedAOI bigint,
FailedAOI bigint,
FPYAOI float,
TestedFUNC bigint,
FailedFUNC bigint,
FPYFUNC float,
RecordID identity(1,1) int)

...

Thanks,
Tom

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2006-02-17 : 14:40:47

How about...

DECLARE @MyRecordCount int

Local variables must begin with @. Cursors don't use the @ notation, so it's interpretting your declare as a cursor not a variable.