Dec 3

Pinoys on LA Galaxy

Pinoys being asked about LA Galaxy…. ‘mga pogi sila…’ was the usual comment. LOL. can someone equate 2 hours of kicking that ball and hitting a curler into being good looking? that’s an insult if you just praise DB for his good looks. He’s a monster with the free kick.


Dec 2

Wolverine Becks

Naglalaro pala ng football si Wolverine?


beckham soccer azkals football wolverine
Nov 24
It seems that it’s in our blood to serve long.. my dad served 12 years, I reached 18 years, I don’t know with my daughter (Sara), if she wants to continue.. It’s up to the people, we will consult the people, if the people allows us to continue, we will serve. Rody Duterte on Civil Service

Nov 15

How to restore a SQL Server 2008 backup into SQL Server 2005 

You Can’t! Yes, you heard me right, you can’t do a straight restore of a backup file from a SQL Server 2008 into a SQL Server 2005. Restoration of back up files can only be done from an old version to a new version. For example , a .bak file from a SQL Server 2000 machine can be restored in 2005 or 2008.

However, don’t lost hope! There’s a work around (just like any other programming challenge).

Do a Generate Script in your 2008 Server. This only works for the full SQL Server 2008 Management Studio Tool. 

1. Open SQL Server 2008 Management Studio Tool

2. Right Click on the database that you want to backup.

3. Look for the Generate Scripts menu after the right click event.

4. A form will pop up, there’s an option on the DATA to be included in the generate script. Choose data along with the structure to be generated.

5. Choose compatibility with SQL 2005 in one of the options.

6. Choose all tables you want to backup restore.

voila

you will have each table having one CREATE TABLE / INSERT RECORDS sql files.


PROSTATE CANCER

Beyond age 60, prostate problems affect up to 80% of men.


Read more on Newsmax.com: Enlarged Prostate, Prostate Problems, DHT, and Prostate Health


What keeps you awake at night? - Only when I ate too much… only indigestion keeps me awake Carlos Slim - $61 Billion Worth, Forbes Richest Man in the planet

Nov 14

  • suicideblonde:

    Top: Brad Pitt and Angelina Jolie arriving in Tokyo, Japan on November 10, 2011 with their childern

    Bottom: Elizbeth Taylor and Richard Burton arrived in Nice, France in 1967 with Taylor’s children Michael and Christopher Wilding, Liza Todd and Maria Burton, the couple’s adopted daughter


    • Via: Suicide Blonde
    Nov 11

    How to make a Cross Tab SQL script

    Executive reports are usually done in a cross-tab manner. The problem with developers is how to do this out of the SQL code directly without any help from Report wizards.

    Usually, when you do a select statement, it will just produce all the records row after row. just like this:

    SELECT Job, LengthStay, Salary FROM Employees

    Results:

    1. Clerk , 10 , 12000

    2. Clerk, 15, 14000

    3. Mgr , 20, 15000

    4. Sales, 15, 11000

    To make it a cross-tab report , just simply use a CASE statement:

    SELECT  Job,

    SUM(CASE WHEN Lengthstay = 10 THEN Salary ELSE 0 END ) as 10Years,

    SUM(CASE WHEN Lengthstay =  15 THEN Salary ELSE 0 END ) as 15Years,

    SUM(CASE WHEN Lengthstay = 20 THEN Salary ELSE 0 END ) as 20Years

    FROM Employees

    GROUP BY Job


    sql crosstab programming
    Nov 10
    AH PHOSPHENES , i thought they were real stars

    AH PHOSPHENES , i thought they were real stars

    (via factsandchicks)


    Via: Facts and Chicks
    newsweek: How could we not open this letter to the editor?! The first paragraph, taken by itself (and typed out on a typewriter nonetheless), is quite the gem: Dear Sir, Before I start this letter to you I just want to say that I don’t have a way to tweet, Dot Com, or e-mailed. Everyone worries about the US Postal service, all they have to do is write a letter and put a .44 cent stamp on it and it’ll get to your mailbox. And you know, it’s kind of nice to go every day to that box and find a letter in it from a friend or a magazine from Newsweek or US World or Time.  Anyway, I hope you will see fit to read it but I doubt that you will. Not only did we read your letter, kind sir, but in a few days you’ll have one of your own in your mailbox, sent from your friends at Newsweek. We agree. It is kinda nice to get mail.

    newsweek:

    How could we not open this letter to the editor?! The first paragraph, taken by itself (and typed out on a typewriter nonetheless), is quite the gem:

    Dear Sir,

    Before I start this letter to you I just want to say that I don’t have a way to tweet, Dot Com, or e-mailed. Everyone worries about the US Postal service, all they have to do is write a letter and put a .44 cent stamp on it and it’ll get to your mailbox. And you know, it’s kind of nice to go every day to that box and find a letter in it from a friend or a magazine from Newsweek or US World or Time. 

    Anyway, I hope you will see fit to read it but I doubt that you will.

    Not only did we read your letter, kind sir, but in a few days you’ll have one of your own in your mailbox, sent from your friends at Newsweek. We agree. It is kinda nice to get mail.


    Via: Newsweek
    My name is Sanborj.
    and this is my life.