generate future dates for multiple entries based on start and end date of each row

i have an issue figuring out the below approach, would appreciate f you can give me a hand with a SQL query to generate the required result (basically i want to generate dates that semi annually Greater than start date and less than or equal end date)


ID Start Date End Date
X 1 Jan 2021 1 Jan 2023
Y 1 Mar 2021 1 Mar 2023
Z 1 Jun 2021 1 Jun 2023

results needed

ID Date
X 1 Jun 2021
X 31 Dec 2021
X 1 Jun 2022
X 1 Jan 2023
y 31 Sep 2021
y 1 Mar 2022
y 31 Sep 2022
Y 1 Mar 2023
z 1 Jan 2022
z 1 Jun 2022
z 1 Jan 2023
z 1 Jun 2023

thanks in advanced

Is it a legal concern if a procedural name generator might generate the names of real people?

(This question is similar in spirit to this question, but I think this case is sufficiently different and specific enough to warrant a new question.)


In one of my current side projects, I have a little procedural name generation system for NPCs. Its purpose is akin to the random profiler in Watch_Dogs and the way it procedurally generates little NPC identities and blurbs to flesh out the game world, in that the system exists to spit out some generic NPC identities and give bits of information about them. Which can sometimes give very funny results, in Watch_Dogs’s case.

The procedural system in my project is fairly basic, and it generates:

  1. a random first name, taken from a list of the most common baby names in North America. (i.e. Anna, Nancy George, William, etc.)
  2. a random last name, taken from a list of the most common surnames in North America. (i.e. Rogers, Smith, Walker, Brown, etc.)

As a result of this dataset, the generator typically spits out generic names like "John Smith" and "Marcy Walker," which is what I wanted it to do and it works as intended.

The question

In the process of testing, I have noticed something about this generation system: because it is specifically designed to generate normal-sounding names that could plausibly exist, it can inadvertently generate the names of real, famous people. For example, it has the potential to spit out "Chris Pine," "Will Smith," "Tom Hanks," and probably a few others, simply because it pulls from lists of common names and could plausibly stumble across and combine those options. From a player’s point of view, it would probably be a little surprising to stumble across an NPC named Tom Hanks just wandering around the world.

This leads me to my question: If I were to ever release this game commercially, is it possibly going to be a legal concern if a procedural name generator sometimes inadvertently spits out the names of famous, real people? Are there other potential ways this could be a problem from a game design standpoint? Would it count as some kind of unauthorized-use-of-identity issue? And, if so, should I program in some "blacklists" of names that the procedural generator should avoid spitting out, i.e. by giving it lists of celebrity names to avoid?

How to generate an heterogeneous mesh

I’d like to generate a mesh with a big variance in cell size. Something like

enter image description here

I’d prefer not to rely on a vertex model and perhaps use something simpler, like VoronoiMesh. Any ideas?

Further comments: I’d simply like to get a mesh-type object with varying cell sizes and similar to the picture above. Not much else is required. When using VoronoiMesh I might need to tweak the distribution of the random points in order to better mimic the image. Simply using VoronoiMesh[RandomReal[1, {300, 2}]], for example, is not "diverse enough". I’ve also heard of weighted Voronoi tessellations, but I want to keep the polygon-shaped mesh. A clustering distribution of points, with multiple clusters, should do the trick, but I’m not sure how to do it.

Generate more views & get likes on Social media (Tips, Group Links)

I had created a blog sharing my own tips and also a few Facebook groups which you could join to promote your content (Facebook, Instagram, Blog, website, etc)

This blog has very good information which will help you get more views/traffic and increase your likes, engagement.

Visit by copy-pasting this Link on your browser:…

Generate more views & get likes on Social media (Tips, Group Links)

How to compare and subtract elements in nested list to generate a new list

I have list of lists like this one:
list={{1, 9, 4, 7, 2}, {1, 4, 7, 1, 8}, {0, 5, 7, 2, 9}}
where every nested list have 5 elements.

I want to compare the third, fourth and fifth elements of each nested list and do the subtraction: the largest number minus the smallest number. The result should create a new list.

In my example, it should work like this:
in the first nested list {1, 9, 4, 7, 2} the largest value between the third, fourth and fifth elements is 7 and the smallest 2, subtraction 7-2=5. So 5 will be the first element in the new list with results. I want to do it with every nested list in my list of list.
For my example, the result will be:

The problem is that I don’t know how to do it. It’s not just comparing the elements between nested lists or extracting specific elements from the lists (because I want to compare and subtract them first, then get the result). Please help!

Generate Aztec triangle of size n automatically´╝č

In the paper titled "Perfect Matchings of Cellular Graphs" by Mihai Ciucu, the Aztec triangle of size n (n= 1, 2, 3, 4, 5, ...) is equivalent to a triangular grid of n1 squares (n1 = 1, 4, 9, 16, 25, ...) .

See the following example: image

Is there a automatical way to generate such patterns? (additionally, is it possiable to get the connected points into a list?)

Also are there some general method to generate Aztec diamond of order n (not just triangle)?

Thank you very much!

How to generate a navmesh from a set of 3D meshes from scratch

I’ve found a great article on how to build a constrained delaunay triangulation that can be used to create a simple navmesh from cutout geometry. However, this does not seem sufficient to generate a high quality navmesh from any arbitrary set of level geometry from scratch.

One of the problems is that it only deals with triangles in XZ space. But how should I handle situations where an arbitrary 3D mesh is intersecting another arbitrary 3D mesh? Within their intersection, each triangle would need to retriangulated in some way.

Why does a project sometimes not generate links?

Hi there! I just saw detail in some projects, I can’t find the reason why this problem happens.
An example:
I had created 3 projects (A, B, and C) same configuration, same everything! after 3 days on:
– Project A, has created 340 verified links and continues to create posts.
– Project B, 282 verified links, and then it is stopped, they do not generate sent links.
– Project C, 61 verified links and now it is stopped, it does not generate sent links.

What could be the problem?