My C# isn't great, especially when code is given in one single (unreadable) line. My guess is that this is a Delimited String Splitter? If so, a simple

Oh... are those apart of the rumoured...

It might also be worth seeing what the SQL that the report is actually running is. Use Extended Events to capture the SQL and run it yourself and see if...

Firstly, let's have something that's (marginally) more readable than a single line of text:

ISNULL returns the value of the second parameter if the first parameter has the value NULL. So, in the case, if the value of c.Folldate is NULL, then the value...

I all honesty, I hate the JET/ACE drivers. I'd take a CSV, tab-delimited, etc, or even a fixed width file over a .xls(x) any day. I least then I can...

It will allocate 700MB when you create it; hence why it's called Initial datafile size. 😉

Duplicate of https://www.sqlservercentral.com/Forums/1905612/Unable-to-build-Visual-Studio-database-solution-when-using-OPENJSON

Use 3NF (3rd Normal Form). You should never be adding extra columns for repeating items, you should be adding extra rows. If you require a unique ID, then add one...