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.