On Wed, May 30, 2018 at 8:21 AM, David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Tuesday, May 29, 2018, tango ward <tangowar...@gmail.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