Loading

Error while using While loop

Aruljothy Sundaramoorthy

6y823SQL

This query throws error as "

Msg 156, Level 15, State 1, Line 7

Incorrect syntax near the keyword 'WHERE'."

please help to resolve this issue.

DECLARE @Counter INT

SET @Counter=1

DECLARE @devicemaxNumber INT

SET @devicemaxNumber=72;

WHILE ( @Counter <= @devicemaxNumber)

BEGIN

PRINT 'select * from Device'+@counter+ WHERE 'Inverter'+@counter+ .localcol between '2020-01-10 00:00:00' and '2020-01-10 23:59:59'

SET @Counter = @Counter + 1

END

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Hey use this.

DECLARE @Counter INT
SET @Counter=1
DECLARE @devicemaxNumber INT
SET @devicemaxNumber=72;
WHILE ( @Counter <= @devicemaxNumber)
BEGIN
PRINT 'select * from Device'+CAST(@counter AS VARCHAR)+ ' WHERE Inverter'+CAST(@counter AS VARCHAR)+'.localcol between ''2020-01-10 00:00:00'' and ''2020-01-10 23:59:59'''
SET @Counter = @Counter + 1
END

0

'Inverter' , remove single quotes

+1