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 can't mod anymore but if I could you would get a funny.
Now I want to hear the rest of the novel.
If he simple function call is giving you a more lazy evaluation evaluation, that might explain what's occurring.
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.
Weasels that know corporate double speak are ruining everything though. You know we don't mourn the T-rex. We talk about the dinosaurs as being really big and dumb.
They were all psychopaths!! Lizard brains.
When the cockroaches are mulling over what our existences might have been like, they will all say that the weasels died out because of our stupidity and overconfidence. They'll say we were monsters, too. Big and dumb. Lizard brains.
Or can you point me to the chapter in the bible where Jesus the carpenter set down his hand tools, stole his neighbor's air compressor, power tools, and precut lumber, and proceeded to craft stuff from it in his own name?
It dulls the impact of an important event,
Which "important event" do you have in mind here? Are you talking about when he opened up a network closet and slowed down the network traffic of an entire academic library for his own aims - when he could have downloaded all the same material from the desk where he worked his job? Or are you talking about when he got scared about the possibility of having to face trial, and took his own life rather than object to the laws that he was potentially facing trial under?
If Slashdot had posted a story about "the Lone Gunmen" pilot episode, then they would have a scoop that anticipated the 9/11 attacks with a civilian airliner, by several months...
Quit being dense. He was specifically referring to the person that jacks the car, not bystanders.
Granted, I guess this is a slightly more interesting story than facebook, the movie but still not that great.
You are still at fault.
If you are still confused I will think of something
It may be that the database engine requires the subquery to break the possibility of a cycle in the code, and sequence the computation.