I’m currently working with MSSQL Server 2005 and why does Microsoft have to make everything difficult? With MySQL, a multiple insert is as simple as INSERT INTO table (columns) VALUES (array of values), (another array of values), … (last array of values). This way works in MS SQL 2008, but that’s another expense.
My current assignment in the office is to export and import MS Access data into a completely different schema in MSS. I will pose a problem at the end of this entry and if someone has a solution, I would be grateful to you.
Multiple insert in MSSQL 2005 Thanks to Pinal Dave for this
USE database_name
GO
INSERT INTO table_name (column1, column2, ... columnN)
SELECT 'value1a', 'value2a', ... 'valueNa'
UNION ALL
SELECT 'value1b', 'value2b', ... 'valueNb'
...
UNION ALL
SELECT 'value1n', value2n', ... 'valueNn'
Problem: How would I do a SELECT…INSERT in the middle of an insert because one or more columns are foreign keys. That way I don’t have to verify my data before inserting. Have the machine do it for me. For instance:
USE database_name
GO
INSERT INTO table_name (column1, column2, ... columnN)
SELECT 'value1a', [SELECT...INSERT], ... 'valueNa'
UNION ALL
SELECT 'value1b', [SELECT...INSERT], ... 'valueNb'
...
UNION ALL
SELECT 'value1n', [SELECT...INSERT], ... 'valueNn'
July 23rd, 2008
A few years ago watching people on Filipino TV wearing parkas bothered me. The country is very hot, yet people wore warm clothings. Nowadays with all the typhoons hitting the nation, I’m excusing such display. However, what bothers me now is the new trend that artists are starting in Philippine showbiz. They are now wearing scarves and shawls.
How cold is it in the Philippines for these “fashionista wannabees” to be wearing scarves and shawls? I strongly believe that fashion compliments the season. Aren’t these people scorching with scarves tightly bundled on their necks? I blame Korean Drama for this trend, but it makes sense in Korea because it’s cold there. Not in the Philippines. Do these people know that every time foreigners see them on TV they are laughing because of their so called “fashion” sense?
Panawagan, Christian Bautista… Hindi ka ba naiinitan sa porma mo?
July 22nd, 2008
According to the Central Intelligence Agency’s (CIA) Factbook, the Philippines has plenty of timber, petroleum, nickel, cobalt, silver, gold, salt, and copper. I will concentrate on the first two.
Timber surplus caused the destruction of several towns in the recent years. I’m defining timber as logged trees. If the forests are bald, then there wouldn’t be anything to resist the strong winds and absorb pouring rain during nature’s annual wrathful visit to the country. We need our rainforests healthy and green. If the rainforests aren’t healthy, flooding, and erosions that causes landslides will always occur during typhoons.
Petroleum is gasoline in it’s pure, unrefined form. Why do we import when we have abundant supply. WORLD POLITICS!!! ‘Nuff said.
Apparently, we have plenty of resources and each social studies class (taught in the Philippines) would tell you that we never use them properly to our own advantage, but to the advantage of foreigners.
July 7th, 2008
It’s Independence Day weekend and for those who will be staying home (like me) during the long weekend, I am recommending the films below. They are all foreign films (not if you’re Japanese or Korean). I have them as part of my tiny DVD collection. They aren’t new. They’re about at least 3 years old already and I’m guessing that most of my readers have not seen them yet. I’m a huge fan of martial arts films especially the ninja and samurai. That’s not the only reason why I’m recommmending them, however. These films possess deeper meaning. I have found those meanings in my own perception. It’s up to you to find for yourself.
I will recommend more films later on.
SHINOBI — The movie contains one of the greatest fight scenes ever shown on film. The hero and heroin possess amazing powers and the fit the actors portraying the characters. Probably one aspect of the movie that made me love it is the cinematography. Amazing, amazing, amazing.
AZUMI I — The first of the two. The history of Azumi; how she became. An excellent display of swordplay. I’m a huge fan of the ways of samurai. I’m a man who adores perfection through simplicity and the samurai way of life is that. Simple, precise, perfect. The pretty face of Azumi is a plus.
AZUMI II — The second installation. The continuation of Azumi’s journey towards cleansing. Aagain, contains a great display of swordplay. Unlike most sequels, this one did not disappoint me. Azumi still looking good especially with a cloak (that’s when she really kicks ass).
SHADOWLESS SWORD — This is a Korean film that I can proudly recommend. Korean films are becoming better and could probably replace Hollywood. The film contains another excellent display of swordplay. A must see.
July 4th, 2008
Before leaving for work, I saw on 24 Oras a report about the couple physicians from Binalbagan, Negros Occidental. Dr. Pearle Tecson Pagunsan and wife Dr. Hazel Chua Pagunsan are serving their community instead of going abroad for better wages. The Pagunsans said that there are opportunities of going abroad promising better life that’s been coming their way, but they chose to stay in Binalbagan and serve their countrymen. These are the models every Filipino should look up to and follow.
Dr. Hazel Pagunsan said that weighing the needs and and love for the work, they both chose the joy in working to help the townspeople of Binalbagan over enslaving themselves overseas for better wages. If every Filipino professional has this mindset, then the Philippines would be one step towards the betterment of the country.
I sound hypocritical given I’m overseas, don’t I? I was fourteen when I migrated to the US. A step that I’ve protested from the beginning. I never wanted to come here, but I had no choice. It was a family choice. Then what am I still doing here now that I’ve grown to have my own decision? I plan to return to the Philippines in the near future. I’m just saving for a fresh start. I don’t exactly have anything if I came back, do I? I’m being patient and I can see the light at the end of the tunnel. I may not be bright enough to offer something for the nation, but I would be one man back.
The Pagunsans are selfless, why would someone like me who is selfish appreciate the act. To me though selfishness boils down to oneself, it does have a layer. Here, I am speaking of national selfishness where the layer is the choice of group. I’m being selfish for the group I belong to. I’m inherently contained in the group and I’m being selfish to achieve my own goals by making sure the group is successful.
What troubles me, though, is that the Pagunsans are also nurses. They took and finished nursing recently. That means they thought or still have thoughts of living the country and nursing foreigners abroad. We’ll see.
June 6th, 2008
Felixberto Baguyo, Jr. posted Wage Increase A Must where he stated that wages in the Philippines aren’t rising despite the rise in cost of living. He pointed the reason that the government did not want to incur additional cost to the investors – who are foreigners and are growing in population. He is correct, however that is not why my heart is heavy on this matter.
OFW population keeps rising. We work for foreigners, while the foreigners are invading us ecconomically and making use of our resources to further advance their economies. Basically what is happening is that the foreigners are taking advantage of the resources that our social studies teachers are praising that we have plenty of, while our own people are shipped outside the country to become slaves of other nations.
It’s really frustrating because we should be the ones to take advantage of our own resources, but what is the government doing? We are deprived of our own possession, instead they are offered to the our masters. We don’t realize it yet, but we really are being colonized. We are once again under the control of other nations.
[pending entry on OFW coming soon]
April 17th, 2008
