Re: reduce number of multiple values to be inserted

On Wed, May 30, 2018 at 8:21 AM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tuesday, May 29, 2018, tango ward <tangoward15(at)gmail(dot)com> wrote:
>>
>> I will repeat the same process for 13 villages so that will be 117 of
>> values. I would like to know if there's a way to reduce the script? This
>> has to be done strictly via script.
>>
>>
> VALUES and CROSS JOIN might help but you haven't explained the pattern
> well enough, if there is one, to know for sure. Frankly, you'll probably
> spend more time figuring out the elegant way than just copy-paste-change so
> unless you need to leverage this elsewhere I'd say just brute-force it.
>
> David J.
>
>
Can you elaborate the idea on brute-forcing this Sir?

Thanks,
J