I have a big process having almost 500+ variables. I want to create a Report table for the same but If I try to add all variables into report table it throws error after 255 column saying "Max column size reached" So tried creating multiple report tables having up to 150+ columns each but then started throwing error saying "Row size too large"
I have 87 columns (each with VARCHAR 255) and with 3 default columns but it is still throwing above error.
I don't know how it works but if I multiply 255*93 gives up to 23000 then Why it is throwing error for above 65535.
Please any solution its urgent