SQL transfer data from one table to another...

<< for tables with exact same columns only >>

//creating new table
SELECT *
INTO new_table
FROM old_table
WHERE condition


// with existing table
INSERT new_table SELECT * FROM old_table

<< for transfer with static value and/or tables with NOT exact same columns only >>

INSERT INTO new_table (columns, columns, columns)
SELECT columns, sum(), static_value FROM old_table
WHERE condition

Outlook: “Can’t Create File” Error When Opening Attachment

1. Click Start > Run and type regedit.

2. Click Edit > Find and type OutlookSecureTempFolder.

3. When regedit has found the entry, it will tell you where your Outlook temporary files are stored. It will look similar to:

C:\Documents and Settings\username\Local Settings\Temporary Internet Files\OLKrandomnumber

4. Open My Computer and navigate to this location on your hard drive.

5. Delete all of the files in this folder.

6. Test open attachment

7. Restart Microsoft Outlook if not able yet

"different...."

haven't blog and updated this for a while... perhaps because of the new twitter, meme, and facebook? nah...

today i stood up and left home for work past 6am... i have lots of things in my mind right now so i took a different path... a path i never havent crossed yet... somehow it felt strange but good... the early walk, the smell of the grass, breakfast alone... it was like going to work on your first day... it was like one of my travels in a different country...

i hope this is a start of a new good beginning in my life...

EDIT: at 6pm of this day, my father died.

I love you Pa. You'll always be here in my heart.
Thank you for everything. We'll surely miss you. Rest in Peace with the Lord.

solved problem: MSSQL Maintenance Plan Save Error "no such interface supported"

i recently encountered a problem in Microsoft SQL 2005 which did not arised in my first server.

Microsoft SQL Management Studio does not allow me to save any Maintenance Plan and pops-up this message:

"no such interface supported"

after long research on the net, solution is very simple.

solution:

regsvr32 msxml3.dll

regsvr32 msxml6.dll

30 second Speech by Bryan Dyson (CEO of Coca Cola)

"Imagine life as a game in which you are juggling some five balls in the air. You name them - Work , Family, Health, Friends and Spirit and you're keeping all of these in the Air. You will soon understand that work is a rubber ball. If you drop it, it will bounce back. But the other four Balls - Family, Health, Friends and Spirit - are made of glass. If you drop one of these; they will be irrevocably scuffed, marked, nicked, damaged or even shattered. They will never be the same. You must understand that and strive for it."

WORK EFFICIENTLY DURING OFFICE HOURS AND LEAVE ON TIME. GIVE THE REQUIRED TIME TO YOUR FAMILY, FRIENDS & HAVE PROPER REST.

Star Wars: New Empire

OLPC, after years of launch... still unbeatable!

this laptop never fail to amaze me. i support this project.