Become a fan of Slashdot on Facebook

 



Forgot your password?
typodupeerror
Note: You can take 10% off all Slashdot Deals with coupon code "slashdot10off." ×
User Journal

Journal Journal: When did I become an incompetent at TSQL? 6

What is wrong with this code? It's like I can have the inner loop execute, or the outer loop execute, but not both.

DECLARE @RC int
DECLARE @BatchMatch varchar(40)
Declare @mcount int
Declare @dcount int

Set @mcount=1
Set @dcount=1

While @mcount 13
        Begin
                while @dcount32
                        Begin
                                Set @BatchMatch=Right('00'+Convert(varchar(2), @mcount),2) + Right('00' + Convert(varchar(2),@dcount),2)
                                Print @BatchMatch

                                Set @dcount=@dcount+1
                        End
                Set @mcount=@mcount +1
        End

PS, no I don't care that all months don't have 31 days, but I must cover months that do.

-------------------------------------------
Update- failed to reset the inner loop counter, that's what.

User Journal

Journal Journal: Clearly I suck 4

My linux skills have atrophied. I need to set up 10 workstations today. I have one done. What is the *easiest* way to clone a partition in ubuntu 14?
--------------------------------------
Update: Ghost 4 Linux and LinuxLive USB Creator to the rescue. I haven't had a usable copy of Ghost since floppies ruled the emergency boot sector, now, I'm going to buy a 32GB keychain drive off of Amazon and make sure I am NEVER without a copy of G4L. Drive imaging in an emergency is just way too useful of a skill to have.

User Journal

Journal Journal: Strange SQL Server 2014 behavior 7

I have a Select Statement that returns 4 rows. When used in a stored procedure as input to an Insert Into, though, it was returning five rows. I commented out SET NOCOUNT ON; which is added by the SQL 2014 template. It then returned 4 rows. To test that was what was really going on, I uncommented out SET NOCOUNT ON; and it is now returning 4 rows properly.

I made no other changes.

Anybody else ever run into anything like this??

User Journal

Journal Journal: When did Net Neutrality change? 26

As late as last year, I remember Net Neutrality being a libertarian free market concept- preventing a crony corporate takeover of the Internet. Now that it is being implemented by the FCC, it has suddenly become a crony corporate (Democrat Brand) takeover of the Internet, that all good libertarians should oppose.

I haven't had political whiplash like this since the Catholic Church went from those nice monks doing AIDS research and running hospice care centers to those bigots who want to keep THOSE people from marrying.

Windows

Journal Journal: One year since XP OEL. 6

Do you realize that XP was EOLed exactly one year ago?
I know many XP machines still chugging around peacefully without problems: No XPcalypse happened. This entirely fits my predictions.

XP was a (had become) a mature operating system. I abhor the fetish of "newer is better" that reigns in our industry.

User Journal

Journal Journal: Found at a Catholic site 39

The legal impossibility of a Christian polity in America is formally declared in the First Amendment of the U.S. Constitution. The so-called 'free speech' and 'free exercise' clauses of the First Amendment are purely secular mandates. They are a rejection of the Catholic notion of the common good, mandating that there be no restraint whatsoever on things that damage souls and ultimately destroy the State itself. They grant as lawful precisely what many popes have called unlawful: unconditional freedom of thought, of speech, of writing, and of worship -- as if these were so many rights given by nature to man. The language of the First Amendment reflects the Protestant-borne, Enlightenment-bred faith of the deistic Framers in the ability of unaided human reason to define and sustain liberty apart from Trinitarian Truth; that is, without a cooperative effort by the Church and the State. Thus, all manner of violations of natural and divine law, including the "right" to murder children in the womb, and the coming "right" to "marry" someone of the same sex, are found lurking in the secular mandates of the First Amendment. The true Church foresees these errors. Oddly enough, the Secular State itself will not be able to endure its own mandates.

Real Users hate Real Programmers.

Working...