Synapse TSQL: variable assignment in SELECT statement cannot be included

When working with synapse as a TSQL developer, it does feel like you've gone in a time warp back to SQL 7.0 in terms of whats supported and whats not. Luckily most of the TSQL patterns not supported have some form of workaround. This one I'm looking at is the naughty practice of doing variable … Continue reading Synapse TSQL: variable assignment in SELECT statement cannot be included

Sample Financial Reports for Adventureworks (Updated)

I updated my AdventureWorks Sample Report to include CashFlow, so we now have the three core areas of GL in one PBIX. Profit and LossBalance SheetCash Flow You can download the PBIX from below link https://1drv.ms/u/s!Aquy5jaDyEyihsVDWoQ9TKyGRzwWSA?e=O4VkYr You can also download the source files from below linkhttps://prodata365-my.sharepoint.com/:u:/g/personal/bob_prodata_ie/EVnrkBMz0atFqswf16Pe6uUB3FHm_qcjDFVnJvop9LaTrA?e=n8du0z To see my sessions on Creating Financial Reports in … Continue reading Sample Financial Reports for Adventureworks (Updated)