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?