CODEWITHSUNDEEP
sqlsql-serversql-server-2005t-sql
ediblecode
ediblecode

Reputation: 11971

Having trouble seeing what's wrong with my syntax here (SP)

It is bringing up an error on line 'Select @RowCount = 1'

declare @RowCount int
declare @MaxRows int
declare @CommonImportID bigint
declare @UserName3

select @RowCount = 1;
select @MaxRows = count(*) from import.commonImport;

while @RowCount <= @MaxRows
begin
EXEC [import].[spExecuteMainProcedure]
     @CommonImportID = 2814,
     @UserName3 = N'dTrunley'
select @CommonImportID = @CommonImportID + 1;
select @RowCount = @RowCount + 1;
end

Just really struggling to see what I've done wrong. Probably something really basic.

Thanks

Upvotes: 1

Views: 42

Answers (1)

Oded
Oded

Reputation: 499072

You didn't define a data type here:

declare @UserName3

Should probably be something like:

declare @UserName3 nvarchar(8)

Upvotes: 4

Related Questions