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).

Good to see you again fustakrakich.

Swing and a miss, Ratzo.
It took a millennium and a half for the reformation to try to straighten out Scripture.
The point I made was that Luther incorrectly removed this.

So which would you use to inform your life and society? If you said, "The Bible", then even God thinks you're a moron. Because, way before there was scripture, there was man's ability to reason.

Read the Gospel; specifically read how Jesus reacted to Thomas' skepticism, and his message about those who haven't seen and still believe.

Man's ability to reason is deeply flawed. Man's "reason" once told the Egyptians it was OK to use the Hebrews as slaves. Man's "reason" today says it's OK for women to butcher their children in the womb.

I'm attacking liberalism as a demonic religion, I'm not attacking religion in general. I, for one, am a proud Catholic and will always remain one.

Typo -- above should read: Martin Luther removed them from his Bible, and also wanted to remove a few other books as well --- James, for example.

Those books were part of the Bible until the Protestant Reformation. Martin Luther removed them from his Bible, and also removed a few other books as well --- James, for example.

But... But... Chicago is a gun-free utopia! No guns are allowed there, so everyone is safe and no one has to worry about getting shot. /sarcasm

That's to be expected. Liberalism was born from the same tree as religion.

You might be surprised, AC, but I agree with this. Modern Liberalism / Progressivism (also known as fascism) is indeed a religion. The State is worshiped as supreme, the environment replaces the saints, and their unholy sacraments are abortion and gay marriage.

In other words, the Devil himself is who they really worship, the Devil just abstracts that out as the State so the leftists don't realize what master they truly serve.

And if there's anyone who wants to dismiss that... get a history book and learn how many Catholic Clergy got the Guillotine in the French Revolution for not dropping their faith in favor of Robespierre's "Reason".

Let's not forget the incorrect retraction of the Bible that removed 6 books. The full Bible has 73 books.

Tobit, Judith, Wisdom, Sirach, Baruch, and I & II Maccabees are all scripture.

What was the last time there was a retraction of inaccurate or harmful material from the Bible?

Most of what you see as inaccurate was intended to be metaphorical, and as far as "harmful"... typical liberal drivel. Anything you don't agree with is "harmful" or "hate speech" or "intolerant".

Play a new card, that one is as worn out as the race card is.