Comment Re:Haven't done T-SQL in years (Score 1) 11
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.
Comment Re:Betteridge answers (Score 1) 381
++no
Comment Re:Haven't done T-SQL in years (Score 1) 11
Again, invoking a subquery is going to let the database engine know: "OK, get all that stuff first, and THEN work on the rest of the query."
If he simple function call is giving you a more lazy evaluation evaluation, that might explain what's occurring.
If he simple function call is giving you a more lazy evaluation evaluation, that might explain what's occurring.
Comment Re:Haven't done T-SQL in years (Score 1) 11
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.
Comment Re: LoL... (Score 1) 278
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...
Comment Haven't done T-SQL in years (Score 1) 11
Is there a threat (even a theoretical one) of the server going into an infinite loop based upon what you're doing?
It may be that the database engine requires the subquery to break the possibility of a cycle in the code, and sequence the computation.
It may be that the database engine requires the subquery to break the possibility of a cycle in the code, and sequence the computation.
Comment Re:Kudos? (Score 1) 8
Take a couple pilz and call me in the morning.
Comment And You Used to Call Me A Paranoid, Tin-Foiler (Score 2) 278
Nah. Not HERE, in the land of the Free, with Rule of Law!
But?
We were right all the time. Unfettered by doctrine, dogma of allegiances, wary of our own cognitive bias, we saw what we saw.
Bitter vindication.
Comment Yes, I'm already aware (Score 1) 11
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).
Journal Journal: Fun with SQL Server 2012 11
I have a Table Valued Function that returns a simple parameterized view. I want to turn that view into a string.
Can anybody tell me why the first query works and the second one doesn't?
DECLARE @JobID INT
DECLARE @strOut VARCHAR(MAX)
SET @JobID=2861
Comment Re:Technically, it's not a "draft notice" (Score 1) 205
To this day, males 18+ must register. Those who do not cannot receive Federal financial aid, nor work as a GS or contract employee for the Fed.
Comment Re:So (Score 1) 310
Did it do a 4G inverted dive?
Comment Re:Kudos? (Score 1) 8
Fungus among us.
Comment Re:ketchup n horseradish (Score 1) 9
He preached Torah?
Harrumph. He makes vague statements about Law, in writings committed 60 years after his crucifixion.
Sermon on the Mount is what he taught.
Journal Journal: These secular priests just keep slicing on the drive 30
It's almost as though we should just quit privileging these guys, or something:
This scientific journal just had to retract 60 papers. How does that even happen?
This scientific journal just had to retract 60 papers. How does that even happen?
