I do want the string built in Sequence Order.

Here's the weird thing- query #2 has been working for 4 months. Not sure what changed, but the explanation that the rows are being fetched slow makes sense (they're always messing with my server settings!).

The Top 800 is included in the subquery because MS SQL returns an error without it- Can't use an Order By in a subquery without a TOP. 800 just happens to be ~5x the current number of Model Points in the Model Points Table (and thus, this function should NEVER return that many rows).

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.

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.

That I'm running a risk with the first of > 800 Model Points, but in my database, I never exceed 80 modelpoints for a given job ID.

But I still don't understand why the subquery is necessary (in some cases).

I wish I could mod this up.

I recently learned Microsoft MVC, being an old application programmer. Once I grasped the concept, I ended up with three competing database models to the same bloody schema in SQL Server, because some controls use AJAX/Entity Framework, others JSON/SQLDataObject, still others a SQLClient loaded on page load.

I got it to work, but what a rube goldberg machine it is, complete with the maintenance headache that implies.

But what it really means is that with this news getting out, Al Qaida is going to start manufacturing cell phone batteries that are half battery (to power up the device and show that it works) and half C4 (bonus, detonation circuit attached to the charger).

I still like the Augustinian Just War. If followed correctly by all sides, it leads to no war. Yet it still protects your people if an aggressor should violate a border.

These days, we could do it with armies of random, but GPS limited, drones pre-programed for air, sea, and land self-healing minefields.

Nope, I'm as against the Death Penalty as I am against abortion- and war as well- for exactly the same reasoning.

But in the mean time, even the Pope has noticed.

Yep- that's it! Even the author, Henry Kissinger fits. Thank you very much indeed.

Given abortion, he didn't.

"But what if I don't sell to foreign nations, to other states, or to Native American tribes?"

Works for me, but the Supreme Court had decreed that if you sell to ANYBODY in dollars, you're engaging in interstate trade.

"I suppose then your idea of communities is that they be what I'll call right now "trade immunity" zones, where as long as it's intra-community, it's sans regulations (besides things like fraud laws)?"

Not necessarily. There's still your LOCAL government to deal with- and they can have all the regulations they can convince their population to follow. But certainly, some libertarian communities, like Colton, Oregon, will keep the regulation down to "Carry a gun with you at all times" and leave it at that.

" And only trade outside the community would be where, in a sense, "foreign policy" considerations would come into play/get factored into trade regulations?"

Exactly. In keeping with the principle of subsidiarity, in which the least competent authority has the authority, and larger governments can't countermand that authority.