Peter Jones

I put a question on the BC Forums about why they are doing what they are doing with Outer Apply.

https://community.dynamics.com/forums/thread/details/?threadid=1f0d5fdf-68fe-ee11-a1fe-7c1e5219011a

You can go to the forums here.

https://community.dynamics.com/forums/thread/?discussionforumid=8ed752fb-7666-4446-ae3f-d44d8a1f7ddb

https://www.bidabrains.com/2023/09/17/bb0009-sending-emails-using-o365/

https://www.bidabrains.com/2023/05/16/bb0008-the-importance-of-short-descriptions/

https://www.bidabrains.com/2023/04/30/bb0007-example-plan-vs-actual-meta5-vs-sql/

https://www.bidabrains.com/2023/04/24/bb0006-why-is-meta5-so-easy-to-use/

https://bida.ro/2024/03/13/bida0044-meta5-as-a-black-box-demo/

https://bida.ro/2024/02/26/bida0043-business-central-staging-area-evaluation-database-available/

https://bida.ro/2024/02/24/bida0042-business-central-tables-and-columns-rename-script/

https://bida.ro/2024/02/18/bida0041-meta5-as-a-black-box/

https://bida.ro/2024/02/18/bida0040-infosys-finacle-version-7-column-table-renames-available/

https://bida.ro/2024/02/11/hd0015-how-do-i-add-a-new-data-disk-pod/

https://bida.ro/2023/10/07/hd0014-how-do-i-run-powershell-commands-in-meta5/

An interesting discussion between IBM and Finacle on how they plan to work together in the future.

https://www.youtube.com/watch?v=_0W8RXG7fjk

An interesting article mentioning the newer finacle Azure offering.

https://www.prnewswire.com/news-releases/zand-bank-subscribes-to-infosys-finacles-corporate-banking-suite-on-microsoft-cloud-to-deliver-new-age-banking-experiences-302106964.html

There are a lot of community blogs on this link. Well worth bookmarking.

https://community.dynamics.com/blogs/

Just for those who want to know.

One way we have come up with to create sequential row number is to use current user as the partitioning column.

This is how we have done it.


select row_number() over (partition by CURRENT_USER order by CURRENT_USER ) sequential_row_count_column


Download of Business Central 2023 Release Wave 2.

https://www.microsoft.com/en-us/download//details.aspx?id=105617

This is a good post about getting the ODBC driver to work.

https://stackoverflow.com/questions/75586420/connecting-to-azure-databricks-from-asp-net-using-odbc-driver

This is where you can get the DataBricks ODBC Driver from:

https://learn.microsoft.com/en-us/azure/databricks/integrations/odbc/download