I have "three" tables in Azure SQL Server:
(The actual names are slightly different and inconsistent; my example is not a misspelling.)
Here's a simplified version of my issue. It returns the correct number of DownloadedBuildingsN, but it only returns 1998 DownloadedRoomsN instead of the full 13360 rows.
Project = 39
Building = DownloadedBuildingsN[@ID]
If I set the last filter to literally any other clause than the ID for DownloadedBuildingsN (or change the formula slightly), it works as expected. I've tried:
BuildingID = ID
BuildingID = DownloadedBuildingsN[@ID]
BuildingID = DownloadedBuildingsN.ID
I suspect this a SQL Server abstraction issue. None of the posts that I've found have been about this problem using Azure SQL Server as the Data Source. But, I hope it's just me misunderstanding.
I will then call SaveData() for offline use.
I've also tried the ForAll-ID-range-divided-by-2000, with the same results.
Session ID: 75dde5f5-30ec-4946-9669-6586fe964668
What am I missing? Thanks.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.