Hi everybody,

Would you please explain why SELECT TOP 1 @ID = ID from myTable where ID > NotExistingID will return the first ID ? I would expect it to return null in this case.

declare @Test table (id int identity, TestFld nvarchar(max))
insert into @Test values ('Test Test Test one more Test')
insert into @Test values ('one two three four five')
insert into @Test values ('once twice once twice once twice')
declare @AllWords nvarchar(max), @ID int, @CurrentID int 
select top 1 @ID = ID, @AllWords = TestFld from @Test
print @ID
select * from @Test 
--while @ID is not NULL
--   begin
--   set @CurrentID = @ID
--select Item, ID from @Test T, dbo.ufn_Alines(T.TestFld,' ')  having COUNT(Item) >=3 
--   select Item from dbo.ufn_Alines(@AllWords,' ') group by Item having COUNT(Item)>=3
--   select top 1 @ID = ID, @AllWords = TestFld from @Test where ID > @CurrentID
--   END

 select top 1 @ID = ID, @AllWords = TestFld from @Test where ID > 3
 print @ID

UPDATE. Re-setting @ID to NULL before this statement helps, otherwise @ID remains the previous @ID. Interesting.