I have a debug problem. When running this code (just a small snippet) with the print statement, I have no problem, but if I remove the print statement or move it above the select, I end up in a loop. Does the print effect the @@Rowcount some how?

	SELECT @RoomDate = RoomDate, @DeptId = DeptId, @DeptDesc = DeptDesc, @RoomId = RoomId, @RoomName = RoomName, @SpaceStart = SpaceStart, @SpaceEnd = SpaceEnd, @SpaceMinutes = SpaceMinutes 
	FROM @OUTPUT 
	WHERE ID = @TempId
	
        print 'Test'

	WHILE(@@ROWCOUNT > 0)
	BEGIN

Thanks for any thoughts.