The attached SQL Script (Procedure) is compiled / written for Azure SQL DW. As such it has code like
DISTRIBUTION = ROUND_ROBIN
,CLUSTERED COLUMNSTORE INDEX
SET @sessionId = session_id()
The above code is supported in regular SQL 2016.
I was wondering if someone could look at the code and let me know what exactly I would need to remove to make it work with SQL 2016.
I appreciate there are 100's of line of code, but if someone could just guide me on how to make it work with SQL 2016 or convert the code (if you have time), that would much appreciated.