3 ms·

Data scientists... And when you look at the query, it'll be 800 lines of SQL...

• hobs 3y ago
  Heh, that's not so bad - 2 jobs ago I had to fix a KPI generation process that was 70k lines of dynamic sql, that unwrapped to up to 1m LOC :)
  • chaz6 3y ago
    Did you ever run into a hard limit of statement size?
    • hobs 3y ago
      No, but all the code generation was happening in the server itself so I dont know how hard and fast it applies, iirc SQL Server's limits are like 64k x packet size.