Forgot your password?
typodupeerror
User Journal

Journal: Fun with SQL Server 2012 2

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?

DECLARE @JobID INT
DECLARE @strOut VARCHAR(MAX)

SET @JobID=2861

SELECT @strOut =Coalesce(@strOut +',','')+ ISNULL('[' +
MP.ModelPointName + '] int', 'ErrorInFactoryModel int')
FROM (SELECT TOP 800 ModelPointName, Sequence
      FROM dbo.GetReferencedModelPointsByJobID(@JobID)
      ORDER BY Sequence) MP
WHERE NOT (MP.ModelPointName LIKE '%Ship%'
        OR MP.ModelPointName LIKE '%Scrap%')

PRINT @strOut

SET @strOut=NULL

SELECT @strOut =Coalesce(@strOut +',','')+ ISNULL('[' +
MP.ModelPointName + '] int', 'ErrorInFactoryModel int')
FROM dbo.GetReferencedModelPointsByJobID(@JobID) MP
WHERE NOT (MP.ModelPointName LIKE '%Ship%'
        OR MP.ModelPointName LIKE '%Scrap%')
      ORDER BY Sequence

PRINT @strOut

The 2nd one returns a single field name, the first, returns all the field names.

User Journal

Journal: Circular Refuge on reddit 4

Journal by Some Woman

It's a happening place. There are upwards of 3, maybe 4 posts a day!
You should join us, if you like.

http://www.reddit.com/r/CircularRefuge
(message mods to join; can't let the riffraff on reddit in! Just our very own special riffraff.)

User Journal

Journal: Trying to remember a conspiracy theory 6

Journal by Marxist Hacker 42

Back in the early 1990s, when CD Roms were first invented, on major use of them was for the conspiracy dial up bulletin board system. With a CD Rom online on your bulletin board, you could "host" a CD full of downloadable text files on everything from government cover-ups to UFOs.

I was into such things at the time, and read many of these files.

Fast forward to today- and Pope Francis gives us a conspiracy theory: that rich first world nations are promoting war in the third world as a prop to economics. All over the first world Catholic blogosphere, there is outrage- how dare the Pope tell us capitalism is supported by warfare?

Of course, Dwight Eisenhower, upon leaving the U.S. Presidency said the same thing,- warned us about the military industrial complex.

But I seem to remember a "secret" document passed around those old BBSs from the Vietnam Era that basically said the same thing, only actually recommending it as a policy. Does anybody else remember this document? Can you remember something I can google on? I'm coming up empty.

User Journal

Journal: Certification fun! 1

Journal by Timex

My employer pretty-well insisted that I get a certification. They went so far as to pay for the training and the first exam attempt.

To that end, I'm working on GCUX through SANS. So far, so good. It's pretty interesting.

From what I'm reading about how to prepare for the exam itself, it would be to my benefit to prepare a thorough index- something in the area of 30-50 pages long. O_O

Does anyone have any experience with that sort of thing? How does one know what should be in the index and what should not?

User Journal

Journal: The more things change... 4

Journal by Timex

...the more they stay the same. I think.

A little over a year ago, I wrote about how I stopped playing WoW and took up ST:TOR. Now, I don't even play that.

Things have been a bit hectic at my house- My wife's computer died (constant, unpredictable reboots and a corrupted hard drive), so she's taken to playing WoW on my system. She raids often, now that she's found a guild that does that sort of thing in the morning. My sleeping period has me getting up late morning. By then, I have an errand or two to do before I start getting ready for work. Rinse, repeat.

I need a vacation.

User Journal

Journal: Which is more dangerous, theology or ideology? 15

Journal by Marxist Hacker 42

This article insists that for human beings, belief is not optional. There are two basic types of beliefs- religious theology and political ideology- but all human beings, even atheists, have some form of belief.
 
  A study of war would seem to indicate that the 20th century clearly showed that ideology is more dangerous than theology, but since fighting for religion has never really gone out of fashion, what do you think?

User Journal

Journal: A geeky theory 8

Journal by Marxist Hacker 42

The multiverse theory is as falsifiable as God himself. Therefore, I have a theory of sociology- that anybody believing in the multiverse has simply fallen for a new religion created by comic books and bad science fiction.

User Journal

Journal: This should be one of those "I told you so" moments... 2

Journal by Timex

...but I won't say it, even though I'd be justified in doing so.

I was just looking through the beta for Slashdot (which I don't like, by the way) and saw a "Hall of Fame" page. I looked at it and this was one of the most popular stories of all time. It was posted when Obama was elected the first time.

It's kind of depressing, in that people were saying that Obama would not change all the things he promised he would, and the lemmings tried to shout them down. I said "depressing" because so many people, all of whom should really have known better, bought into the ideals that Obama sold to them. They honestly believed (and I daresay still believe, even now) that Obama would have the power to bring about all the changes he promised.

Well, it's been six years in. I think I am safe in stating that none of his promises have been kept-- none of them that were of any substance, anyway.

I can only hope that the process that we have in place will work as it should, and Obama will not see the end of the current term. He can't complain: he has his phone, he has a pen, and he knows how to use them.

Windows

Journal: Reminiscence XP 6

Journal by jawtheshark
As I said in my previous journal entry, I'd install Windows XP Home (OEM) in a Virtual Machine today in order to commemorate the death of XP. I documented it with screenshots. Yes, I know, it's Facebook album, but it's public. It was the quickest way to get something online.
From VM creation and installation from SP3 OEM ISO to fully patched in 1 hour and 30 minutes. Not all that shabby.
It also indicates that XP will most likely die totally when they turn off the activation servers. I don't think they'll hand out the promised "no activation patch", ever. (Well, I always heard they'd promised such a thing, it might simply be legend.)

They are relatively good but absolutely terrible. -- Alan Kay, commenting on Apollos

Working...