I thought the table valued function call was already doing that, but that does point to an answer- perhaps it's only fetching the one row before evaluating the concatenation.

Actually, the key thing for them is "cheap". They need to keep costing sub-$1k missiles in the ballpark of these Iron dome systems - the more, the better. They might as well just omit the warheads to save money and increase range. Every $50k shot Israel fires with those systems costs 25 Israelis' annual tax contribution to the IDF. Every $55m system they deploy costs 27.500 Israelis' IDF tax contributions.

Palestinians are poor, but they're not *that* poor that they can't leverage those kind of lopsided financial ratios.

I can't help but picture a sign on the door at the exit of an airport in Israel. It reads "Thank-you for not stirring up ancient inter-tribal conflict".

Now I can't help but think of this excellent video :)

Using a nuclear device at high altitude? You do know what happens if you do that, right? That one test bomb knocked out street lights and long distance phone service nearly 1000 miles away and took out a third of all satellites in orbit around Earth at that point in time.

No, in the case of Iron Dome, that's only PR too. They're shooting $50k+ missiles at $800 rockets. Even after factoring in that Israel's per-capita GDP is 20 times that of Palestine's, that's still a losing proposition, even *if* they had a 100% hit rate (which this article is suggesting it's anything-but) and assuming that you get the launcher, radar, etc for free instead of the actual $55 million per unit. It's in Palestine's best interests that Israel deploy as many of them as possible and try to shoot down every last rocket, because every shekel they spend on Iron Domes and missiles is a shekel they don't spend on jets, tanks, and bombs.

What the hell is a "threat actor"?

Why use jargon when "criminal" is a perfectly good word? And if this is a specific type of criminal, say a terrorist or a thief or the intelligence apparatus of a foreign country, then there are very descriptive and precise words for those as well. If it's corporate espionage, then "crook" works well, too.

Why do people who use technology feel the need to create neologisms for the most mundane things? Just the other day, I saw someone from a news web site refer to an "article" as an "explainer cardstack". I'm not shitting you. I immediately took that news source out of my RSS feed because if they're that dedicated to lexical obfuscation, I don't trust anything they write.

English motherfucker. Do you speak it?

I am interested in watches.

Whether or not a smart watch is worth it is an open question. If they can provide me something that I think I need with it, then sure. I've outlined a list in comments on previous stories, for quasi-trolls that were about to lash into me for being so general.

But I wear an automatic mechanical beater right now—specifically because it's virtually indestructible, represents only a minor investment (and thus financial risk), and requires no maintenance, attention, or battery-swapping. It's accurate to about 2 minutes per year, which means that about once a year I tune the time on it.

Most of the stuff that smartwatches are currently being said to do I either don't care about (fitness tracking, health monitoring) or currently use a smartphone for with far less hassle (bigger screen, more natural UI) so it'll be a stretch. But I'm open.

The "BDS movement" is nothing more than the continuation of Hitlerism

So, not investing in companies that support the Israeli government is exactly the same as the Holocaust?

That's reasonable.

You can have a smart watch. I want a smart ass.

No, in recent history, these conflicts are resolved by pressure from the international community. It's how apartheid in South Africa ended, to a great extent.

I don't know if you're old enough to remember Ronald Reagan and Margaret Thatcher referring to Nelson Mandela as a "terrorist" and his party as a "terrorist organization". It turned out they were dead wrong. Last year, the philosophical progeny of Reagan and Thatcher hailed Mandela as a hero.

History is not going to be kind to the government of Israel in the first decades of the 21st century (if not longer).

It didn't have to be this way.

Did you read that Wikipedia article you linked to? It makes a pretty good case that it's apartheid:

The analogy has been used by scholars, United Nations investigators, human rights groups and critics of Israeli policy, some of which have also accused Israel of committing the crime of apartheid.[2][3] Critics of Israeli policy say that "a system of control" in the Israeli-occupied West Bank, including Jewish-only settlements, the ID system, separate roads for Israeli and Palestinian citizens, military checkpoints, discriminatory marriage law, the West Bank barrier, use of Palestinians as cheap labour, Palestinian West Bank enclaves, inequities in infrastructure, legal rights, and access to land and resources between Palestinians and Israeli residents in the Israeli-occupied territories resembles some aspects of the South African apartheid regime, and that elements of Israel's occupation constitute forms of colonialism and of apartheid, which are contrary to international law.[4] Some commentators extend the analogy, or accusation, to include Arab citizens of Israel, describing their citizenship status as second-class.[12]

You know the old expression about "looking like a duck and walking like a duck and sounding like a duck"? Well, Israel has been quacking for quite some time now when it comes to it's treatment of Palestinians.

Apartheid. There's an app for that.

I didn't explain the behavior adequately.

SELECT * FROM dbo.GetReferencedModelPointsByJobID(@JobID)

Returns someplace between 2-56 rows, depending on JobID

The second query does NOT error out, but is not returning a comma delimited string of all rows, but instead, in some cases, is returning only ONE row.

Since I'm using this to build a temp table, it doesn't error out until I attempt to fill columns in the temp table that do not exist.