Forgot your password?

Comment: Re:Haven't done T-SQL in years (Score 1) 11

by Marxist Hacker 42 (#47437797) Attached to: Fun with SQL Server 2012

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.

User Journal

Journal: Fun with SQL Server 2012 11

Journal by Marxist Hacker 42

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?


SET @JobID=2861

Comment: Re:Cry Me A River (Score 1) 586

by Marxist Hacker 42 (#47425047) Attached to: Normal Humans Effectively Excluded From Developing Software

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.

Comment: Re:Christmas is coming early this year (Score 1) 685

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

Comment: Re:For a well-written refutation (Score 1) 30

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.

God made machine language; all the rest is the work of man.