Posted in Programming, SQL Server on March 25th, 2007 No Comments »
I use this Anti Semi Join query at work frequently,
select * from #tableA a where a.ID not in (select ID from #tableB b)
The purpose of the query is to return all the records in temporary table #tableA that their IDs do not appear in temporary table #tableB. This is a typical Anti Semi Join operation. […]
Posted in Programming, SQL Server on March 12th, 2007 2 Comments »
For a long time the only way to send email in your SQL query is to use the system store procedure xp_sendmail. To use this system store procedure you have to enable SQL Mail which relies on MAPI protocol and you will have to create a mail profile on the server. That was prior to […]
Posted in Money Talks on March 9th, 2007 No Comments »
I have been watching every IPO for chinese companies for the past 2 years. Everyone of them is doing good. They are all traded at a price that is much higher than their offering prices.
Shanda Interactive Entertainment Ltd. (SNDA) is an online game producer and operator. It was offered at about $14 at IPO […]
Posted in News & Comments on March 8th, 2007 1 Comment »
If you look at the photos you may mistaken that the crowd is waiting for the opening of an on sale.
It is actually job fairs in the city of Beijing and Yantai in China. There will be 5 million college graduates in 2007. In a country that has 1.2 billion population scenes like this […]
Posted in Money Talks on March 6th, 2007 1 Comment »
It caught my attention when I found the stock price of new century finance tumble more than 70 percent yesterday. I used
to work for Encore Credit Corporation whose two cofounders came out from New Century Finance. Some of my former coworkers at Encore Credit went to New Century Finance when Encore Credit went under. […]
