For rooted phone
Adfree - removes most ads
Titanium Backup - excellent for backup/restoring applications to phones
Spare Parts - check battery/cpu utilization and more tweaks to the phone
Wifi Tether - turn your phone into mobile hotspot (ad-hoc mode only, infrastructure mode in v3, requires supporting kernel)
CIFSManager - This allows the phone to mount a network drive.
Regular applications
Amazon mp3 - used to hate this but the addition of Amazon cloud player makes this a nice app.
Barcode scanner - very useful in scanner barcode.
Google Voice - free unlimited SMS, cheap international calls.
Advanced Task Killer - useful for killing some applications
ES File Explorer - very good file explorer
Handcent SMS - good messaging app
Pandora - good music streaming app
TuneIn Radio - good online radio app
直讀中文 (cbook) - good ebook reader designed for haodoo.net
LunaTerm - chinese telnet app, good for ptt
PocketCloud - good remote desktop application
RockPlayer - good video player that plays mkv. Now supports hardware acceleration!
LauncherPro - good, fast launcher
Monday, December 27, 2010
Saturday, December 18, 2010
Samsung Epic GPS fix
Here are another the simple solution to fix GPS issue on Samsung Epic 4G:
1. Enter *#1472365# in the dialer
2. Tap Setup, select Position Mode, select Starting Mode
3. Change the option from “Hot Start” to “Cold Start”
1. Enter *#1472365# in the dialer
2. Tap Setup, select Position Mode, select Starting Mode
3. Change the option from “Hot Start” to “Cold Start”
Thursday, October 21, 2010
Install MobileAP on Samsung Epic
-- update 4/19/2011 --
This no longer works on Froyo (EC05). Use Wifi Tether v3 instead after you root the phone. Beware, Wifi Tether sometimes is iffy and can really mess up your phone!
This no longer works on Froyo (EC05). Use Wifi Tether v3 instead after you root the phone. Beware, Wifi Tether sometimes is iffy and can really mess up your phone!
- Download one click root and root the phone
- Install Titanium backup from the market and remove Sprint hotspot
- Download MobileAP and put it on the sd card
- Download clockwork recovery
- Boot into clockwork recovery, apply the zip file from step 3
- Reboot the phone and goto Settings>Wireless and network>Mobile AP Settings to enable MobileAP
Friday, October 1, 2010
SERO Premium
If you are on a SERO plan and wanted a new phone, now is your chance. Sprint finally allows SERO accounts to get "iconic" or "4G" phones (WebOS, Android etc) after $10 buy up to become "SERO Premium". This $10 buy up also offers Any-mobile and Sprint navigation. If you want a 4G phone (Evo or Epic) you have to pay another $10 premium data add-on. If you have a phone ready remember to call 1-888-211-4727 from a landline so employee care can activate your new phone immediately. Below is my new plan
Friday, September 3, 2010
Nokia n900 first impression
Update 10/13/10
Unfortunately due to NokiaUSA screwing my $280 rebate I have to return the phone for refund. I like the phone, but the problem is that it's too much of a computer than a phone as the phone requires a lot of tweaking to make it really work. Coupled with the lack of applications and nokia support I probably won't recommend the phone to anyone else unless they are really into Linux.
--
Just got my Nokia n900 last night. Played with it for a while and setup somethings. So far so good. Here's some of my first impressions. Will continue to update the page as I go through the phone/apps.
Build
About same size as my Touch Pro2 (TP2) but lighter. Build quality is good, I'd rate it a grade below Nexus one and on par with TP2. Physical keyboard is nice, but having 3 rows only really limits the typing speed compare to the excellent keyboard on TP2. I also like that they have a sliding door and a dedicate button for the camera, makes it a lot more useful in real life situation.
OS
Maemo is a fine OS. Smooth UI and good multi-tasking. Unfortunately it's simply not as intuitive or user-friendly as Android or iOS at this point. The UI definitely has a strong Linux feel, but it's fairly usable. The concern is that Nokia has officially said Meego will not be commercially available on n900, but hopefully the active community can pick up slack and port it to n900.
Communication
Haven't been able to test the phone functionality, but this is more like a tiny laptop computer than a phone. n900 has skype, sip client, and tons of other IM clients (MSN, jabbar, ICQ, AIM, google talk etc) built in and it is relatively straightforward to setup.
Skype: There's no dedicate interface for skype, instead it is built in to the system. Voice and video calls work right off the bat. There were some high-pitch noises when n900 is talking to pc via skype, but I am not sure if that's because of my limited upload bandwidth or some other factor. Nevertheless it's very nice to see skype works well on n900, considering that they have refused to release an android client...
SIP: Setting up SIP with sipgate.com is a breeze. I was able to make VoIP calls between n900 and my nexus one (with Sipdroid) through WiFi. Voice is clear with some slight delays, but very usable.
Google Voice: You can get a google voice plugin from the app manager. I've only tested the text part. It works but since it does not support push functionality (a.k.a. google voice on android), it takes a while to have other people's text messages show up on the phone.
Applications
Maemo simply does not have the sheer amount of applications available on Android and iOS, and I am still exploring this aspect, but some built-in applications are really nice.
Browser: I'd say this is one of the best browser on mobile platforms I've used, second only to the browser on android 2.2. Pages render fast and correctly. Flash support make the browsing more complete. The browser also supports ad-block plus plugin to eliminate some ads. Unfortunately there's no multi-touch on the phone so sometimes it's hard to zoom-in zoom-out of a page. Also the flash is an older version instead of the newer hardware-accelerated 10.1 available on android. But overall a very nice browsing experience.
Unfortunately due to NokiaUSA screwing my $280 rebate I have to return the phone for refund. I like the phone, but the problem is that it's too much of a computer than a phone as the phone requires a lot of tweaking to make it really work. Coupled with the lack of applications and nokia support I probably won't recommend the phone to anyone else unless they are really into Linux.
--
Just got my Nokia n900 last night. Played with it for a while and setup somethings. So far so good. Here's some of my first impressions. Will continue to update the page as I go through the phone/apps.
Build
About same size as my Touch Pro2 (TP2) but lighter. Build quality is good, I'd rate it a grade below Nexus one and on par with TP2. Physical keyboard is nice, but having 3 rows only really limits the typing speed compare to the excellent keyboard on TP2. I also like that they have a sliding door and a dedicate button for the camera, makes it a lot more useful in real life situation.
OS
Maemo is a fine OS. Smooth UI and good multi-tasking. Unfortunately it's simply not as intuitive or user-friendly as Android or iOS at this point. The UI definitely has a strong Linux feel, but it's fairly usable. The concern is that Nokia has officially said Meego will not be commercially available on n900, but hopefully the active community can pick up slack and port it to n900.
Communication
Haven't been able to test the phone functionality, but this is more like a tiny laptop computer than a phone. n900 has skype, sip client, and tons of other IM clients (MSN, jabbar, ICQ, AIM, google talk etc) built in and it is relatively straightforward to setup.
Skype: There's no dedicate interface for skype, instead it is built in to the system. Voice and video calls work right off the bat. There were some high-pitch noises when n900 is talking to pc via skype, but I am not sure if that's because of my limited upload bandwidth or some other factor. Nevertheless it's very nice to see skype works well on n900, considering that they have refused to release an android client...
SIP: Setting up SIP with sipgate.com is a breeze. I was able to make VoIP calls between n900 and my nexus one (with Sipdroid) through WiFi. Voice is clear with some slight delays, but very usable.
Google Voice: You can get a google voice plugin from the app manager. I've only tested the text part. It works but since it does not support push functionality (a.k.a. google voice on android), it takes a while to have other people's text messages show up on the phone.
Applications
Maemo simply does not have the sheer amount of applications available on Android and iOS, and I am still exploring this aspect, but some built-in applications are really nice.
Browser: I'd say this is one of the best browser on mobile platforms I've used, second only to the browser on android 2.2. Pages render fast and correctly. Flash support make the browsing more complete. The browser also supports ad-block plus plugin to eliminate some ads. Unfortunately there's no multi-touch on the phone so sometimes it's hard to zoom-in zoom-out of a page. Also the flash is an older version instead of the newer hardware-accelerated 10.1 available on android. But overall a very nice browsing experience.
Sunday, August 29, 2010
Tuesday, August 10, 2010
Credit card bonus cash back
A little reminder to myself
Amex Costco TruEarnings Business
4% Gas, 3% Restaurant, 2% Travel, 1% everything
Amex Costco TruEarnings
3% Gas and Restaurant, 2% Travel, 1% everything
Citi World Dividend
5% home improvement, home furnishing and home and garden 4/1/11~6/30/11
5% airline, hotel, and car rental 7/1/11~9/30/11
1% everything else
Discover
5% Home improvement, department store, clothing store. 4/1/11~6/30/11. Up to $400 in spending.
5% Grocery and drug stores. 6/1/11~6/30/11. Up to $200 in spending.
5% in gas, hotel and theme parks. 7/1/11~9/30/11. Up to $300 in spending
5% in restaurants, clothing and department stores. 10/1/11~12/31/11. Up to ? in spending.
US Bank Flexperk Travel Visa
2% Grocery. 1% everything.
Chase Freedom
5% Home improvement, lawn and garden, home furnishing 4/1/11~6/30/11. Up to $1500 in spending
5% Gas, hotels and airlines 7/1/11~9/30/11.
5% Dining, Department stores, movie theaters 10/1/11~12/31/11.
1% everything else
Target Red card
5% instant off almost everything at Target
Amex Costco TruEarnings Business
4% Gas, 3% Restaurant, 2% Travel, 1% everything
Amex Costco TruEarnings
3% Gas and Restaurant, 2% Travel, 1% everything
Citi World Dividend
5% home improvement, home furnishing and home and garden 4/1/11~6/30/11
5% airline, hotel, and car rental 7/1/11~9/30/11
1% everything else
Discover
5% Home improvement, department store, clothing store. 4/1/11~6/30/11. Up to $400 in spending.
5% Grocery and drug stores. 6/1/11~6/30/11. Up to $200 in spending.
5% in gas, hotel and theme parks. 7/1/11~9/30/11. Up to $300 in spending
5% in restaurants, clothing and department stores. 10/1/11~12/31/11. Up to ? in spending.
US Bank Flexperk Travel Visa
2% Grocery. 1% everything.
Chase Freedom
5% Home improvement, lawn and garden, home furnishing 4/1/11~6/30/11. Up to $1500 in spending
5% Gas, hotels and airlines 7/1/11~9/30/11.
5% Dining, Department stores, movie theaters 10/1/11~12/31/11.
1% everything else
Target Red card
5% instant off almost everything at Target
Monday, August 9, 2010
Chicago Point of Interest
Supermarkets
Mitsuwa (Japanese supermarket, food court, bakery)
100 East Algonquin Road
Arlington Hts, IL 60005-4618
(847) 956-6699
H-Mart (Korean supermarket, food court at Civic Center Dr. location)
801 Civic Center Dr.
Niles, IL 60714
847-581-1212
8:00 AM ~ 11:00 PM
1295 E. Ogden Ave
Naperville, IL 60563
630-778-9800
8:00 AM ~ 10:00 PM
宏源 (Chinese Supermarket)
665 Pasquinelli Drive
Westmont, IL 60559-1284
(630) 323-8180
大家發
6120 West Dempster Street
Morton Grove, IL 60053-2951
(847) 929-2228
Restaurants
台灣小吃
International Plaza
665 Pasquinelli Drive
Westmont, IL 60559-1284
趙老二 (河北菜)
665 N Cass Ave
Westmont, IL 60559
(630) 323-9393
Mitsuwa (Japanese supermarket, food court, bakery)
100 East Algonquin Road
Arlington Hts, IL 60005-4618
(847) 956-6699
H-Mart (Korean supermarket, food court at Civic Center Dr. location)
801 Civic Center Dr.
Niles, IL 60714
847-581-1212
8:00 AM ~ 11:00 PM
1295 E. Ogden Ave
Naperville, IL 60563
630-778-9800
8:00 AM ~ 10:00 PM
宏源 (Chinese Supermarket)
665 Pasquinelli Drive
Westmont, IL 60559-1284
(630) 323-8180
大家發
6120 West Dempster Street
Morton Grove, IL 60053-2951
(847) 929-2228
Restaurants
台灣小吃
International Plaza
665 Pasquinelli Drive
Westmont, IL 60559-1284
趙老二 (河北菜)
665 N Cass Ave
Westmont, IL 60559
(630) 323-9393
Tuesday, July 27, 2010
Tuesday, July 20, 2010
Friday, July 16, 2010
Tuesday, June 1, 2010
Individual plan comparison for AT&T, Sprint, T-Mobile, and Verizon wireless (revisited)
Decided to revisit the plan pricing based on the latest phone each carrier has as well as the total cost. The earlier post is here. All prices are calculated based off my company's discount (20% for AT&T and Sprint, 22% for Verizon).
The best phone for each carrier IMO is
AT&T: New iPhone (release this June). Should be $199.99 after 2 year contract
Verizon: Driod Incredible. $199.99 after 2 year contract
Sprint: HTC Evo. $199.99 after 2 year contract
Sprint SERO: HTC Touch Pro2. $199.99 after 2 year contract
T-Mobile: Google Nexus One. $179.99 after 2 year contract or $529.99 unlocked.
Notes:
* With Free iPhone App
+ With Google Voice
** $10/month charge on top of Sprint Everything Data plan and SERO Premium
++ with T-Mobile $10/month data plan. Require manual change to network configuration.
*** No discount on the $15/200MB data plan
As we can see, with this $10/month charge for Evo Sprint's offering is no longer as attractive as it once was especially if you are not in 4G area. In fact, it is now the most expensive plan out of all four carriers. Granted, to get the price down on the other 3 you need some work around to get free text, but that's precisely the problem with Sprint as they don't offer you any options. I was surprised that T-mobile's total cost with N1 is about the same as AT&T or Verizon, guess iPhone really wasn't that expensive after all..
--update 6/3/10 --
Looks like AT&T updated it's data pricing for smart phone. Now you can get either 200MB/$15 or 2GB/$25, but no more unlimited data plan. Chart updated based on new pricing. I don't like the plan as I use a LOT of data on my phone, but I guess it lowers the barrier of entry to iPhone...
The best phone for each carrier IMO is
AT&T: New iPhone (release this June). Should be $199.99 after 2 year contract
Verizon: Driod Incredible. $199.99 after 2 year contract
Sprint: HTC Evo. $199.99 after 2 year contract
Sprint SERO: HTC Touch Pro2. $199.99 after 2 year contract
T-Mobile: Google Nexus One. $179.99 after 2 year contract or $529.99 unlocked.
| Sprint SERO-P | Sprint ERRP | Sprint | AT&T | Verizon | T-mobile | |
| Minutes | 500 | 500 | 450 | 450 | 450 | 500 |
| M2M | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited | Unlimited |
| N&W | Unlimited | Unlimited | Unlimited | 5000 | Unlimited | Unlimited |
| Data | Unlimited | Unlimited | Unlimited | 200MB/2GB | Unlimited | Unlimited++ |
| Text | Unlimited | Unlimited | Unlimited | Unlimited* | Unlimited+ | Unlimited+ |
| Other | - | GPS Nav. | GPS Nav. | Rollover | - | No contract, expensive phones |
| Price | $50** | $69.99** | $65.99** ($79.99) | $46.99***/$51.99 ($54.99/$64.99) | $54.58 ($69.98) | $39.99 |
| Total Cost (for 2 years) | $920 | $1880 | $1784 ($2120) | $1328/$1448 ($1760) | $1524 ($1880) | $1490 |
Notes:
* With Free iPhone App
+ With Google Voice
** $10/month charge on top of Sprint Everything Data plan and SERO Premium
++ with T-Mobile $10/month data plan. Require manual change to network configuration.
*** No discount on the $15/200MB data plan
As we can see, with this $10/month charge for Evo Sprint's offering is no longer as attractive as it once was especially if you are not in 4G area. In fact, it is now the most expensive plan out of all four carriers. Granted, to get the price down on the other 3 you need some work around to get free text, but that's precisely the problem with Sprint as they don't offer you any options. I was surprised that T-mobile's total cost with N1 is about the same as AT&T or Verizon, guess iPhone really wasn't that expensive after all..
--update 6/3/10 --
Looks like AT&T updated it's data pricing for smart phone. Now you can get either 200MB/$15 or 2GB/$25, but no more unlimited data plan. Chart updated based on new pricing. I don't like the plan as I use a LOT of data on my phone, but I guess it lowers the barrier of entry to iPhone...
Friday, May 21, 2010
$5 Amazon MP3 Store Credit for Downloading Select Free PC Game Demos
Free $5 MP3 credit to download on Amazon MP3 when you “purchase” certain free games.
Rise of Prussia Demo [Game Download]
Europa Universalis Rome Gold Demo [Game Download]
Achtung Panzer Kharkov 1943 [Demo]
East India Company Collection [Demo]
The credit is per account so "purchase" 1 is enough . You don't even need to download the demo, just click on "I'll download later" after purchasing.
Rise of Prussia Demo [Game Download]
Europa Universalis Rome Gold Demo [Game Download]
Achtung Panzer Kharkov 1943 [Demo]
East India Company Collection [Demo]
The credit is per account so "purchase" 1 is enough . You don't even need to download the demo, just click on "I'll download later" after purchasing.
Friday, May 14, 2010
Google Voice invites for students
if you have a .edu email, you can get a google voice invite. A pretty good service I'd say. Fairly good rate for international calls too.
http://www.google.com/googlevoice/students.html
http://www.google.com/googlevoice/students.html
Friday, May 7, 2010
Office Depot $10 off $30 or less Printable Coupon exp 5/9
Sid Meier's Civilization IV: The Complete Edition (PC) Game $10
Through the weekend Steam has Civilization IV: The complete edition pc game for sale at $10.
Linky For Civ4
It includes the main game and 3 expansions.
* Civilization IV®: Warlords
* Civilization IV: Beyond the Sword
* Civilization IV: Colonization
* Civilization® IV
They also have Civilization III complete edition for sale at $1.25!
Linky for Civ3
Linky For Civ4
It includes the main game and 3 expansions.
* Civilization IV®: Warlords
* Civilization IV: Beyond the Sword
* Civilization IV: Colonization
* Civilization® IV
They also have Civilization III complete edition for sale at $1.25!
Linky for Civ3
50% off Starbucks Frappucinos "Happy Hour" May 7-16th after 3-5pm
Starbucks is doing a promotion on their Frappucinos from 5/6 ~ 5/16 every afternoon from 3~5pm.
Link for detail
Link for detail
Monday, May 3, 2010
Garmin nüvi 260W for $99.99 on Amazon.com
Garmin nüvi 260W 4.3-Inch Widescreen Portable GPS Navigator
$99.99 @ Amazon.com. A good price for this GPS unit.
Technical Details
$99.99 @ Amazon.com. A good price for this GPS unit.
Technical Details
- GPS system preloaded with City Navigator North America NT
- 4.3-inch touchscreen display with 2D/3D mapping perspective
- Turn-by-turn directions with voice guidance and text to speech
- Rechargeable lithium-ion battery makes it convenient for navigation by car or foot
- Includes JPEG picture viewer, world travel clock with time zones, currency converter, measurement converter, calculator and more
Thursday, April 29, 2010
Wednesday, April 28, 2010
Kids educational books $0.99 sale!
Bookcloseout.com has quite a lot of kids books for sale at $0.99 each.
Linky
You can sign up their newsletter and you should get a $5 off $35 coupon in the email to offset some shipping costs.
Linky
You can sign up their newsletter and you should get a $5 off $35 coupon in the email to offset some shipping costs.
Nintendo Wii Console with Wii Sports + Bonus Game of your choice for $199.99
Wii + Wii Sports + 1 bonus game for $200
Select a wii system and one of the following games for $200. No tax for most people.
Game choices:
Wii Sports Resort + Wii Motion Plus
Wii Play + Wii controller
Super Smash Bros. Brawl
Endless Ocean: Blue World
I recommend either Wii Sports Resort or Wii Play because of the extra controller/accessory included.
Select a wii system and one of the following games for $200. No tax for most people.
Game choices:
Wii Sports Resort + Wii Motion Plus
Wii Play + Wii controller
Super Smash Bros. Brawl
Endless Ocean: Blue World
I recommend either Wii Sports Resort or Wii Play because of the extra controller/accessory included.
Tuesday, April 20, 2010
Friday, April 16, 2010
Tuesday, April 13, 2010
Six Flags Adult Admission for Childs Price thru 10/11/10
Present a pack of Stride Gum with this coupon and you can get general admission for child price.
Coupon Link
Good til 10/11/10.
Coupon Link
Good til 10/11/10.
Monday, April 12, 2010
Dell small business 20% off select Electronics, Software and Accessories
Enter this coupon* code during checkout: BQG?93HJKS81D2.
Good until 5/3/2010.
One coupon per customer. One time use only. Non-transferable. Offers not combinable with other offers, discounts or coupons. Limit of 5 promotional items per customer. Excludes: cameras, camcorders, gaming, software volume licensing, downloadable software, Dell branded ink/toner and projector bulbs, Dell port replicators, Dell docking stations, Dell batteries, VOIP, TVs, video conferencing solutions and all products from Tumi, PNY Quadro Cards,Yamaha, Bose Speakers, Monster Cable and Wacom.
Good until 5/3/2010.
One coupon per customer. One time use only. Non-transferable. Offers not combinable with other offers, discounts or coupons. Limit of 5 promotional items per customer. Excludes: cameras, camcorders, gaming, software volume licensing, downloadable software, Dell branded ink/toner and projector bulbs, Dell port replicators, Dell docking stations, Dell batteries, VOIP, TVs, video conferencing solutions and all products from Tumi, PNY Quadro Cards,Yamaha, Bose Speakers, Monster Cable and Wacom.
Sunday, April 11, 2010
Thursday, March 18, 2010
Gap, Banana Republic, Old Navy - Friends and Family Event 3/18-3/21 30% off
Wednesday, March 17, 2010
Thursday, March 11, 2010
Saturday, March 6, 2010
Thursday, March 4, 2010
Sql: compare dates without time in sql server
The datetime field in sql server contains both date information and time information e.g.,
expire_date =
2009-12-10 11:50:24.407
This sometimes makes date comparison difficult since when we do
WHERE expire_date = '12/10/2009'
we are actually comparing
2009-12-10 11:50 to 2009-12-10 12:00
To get around this problem, we can use the following syntax
WHERE
CONVERT(datetime, CONVERT(VARCHAR(10), expire_date, 112)) = '12/10/2009'
The trick here is to use two convert functions. The first one converts expire_date into a string of format yyyymmdd (ISO standard, see here), thus stripping out time information. The second convert then converts the string back to datetime format.
expire_date =
2009-12-10 11:50:24.407
This sometimes makes date comparison difficult since when we do
WHERE expire_date = '12/10/2009'
we are actually comparing
2009-12-10 11:50 to 2009-12-10 12:00
To get around this problem, we can use the following syntax
WHERE
CONVERT(datetime, CONVERT(VARCHAR(10), expire_date, 112)) = '12/10/2009'
The trick here is to use two convert functions. The first one converts expire_date into a string of format yyyymmdd (ISO standard, see here), thus stripping out time information. The second convert then converts the string back to datetime format.
Wednesday, March 3, 2010
Napster 60 FREE song credits
Go to the following link
https://sms.napster.com/ns/registration/standard/create_account.html
Create an account and enter the code
CUST57VT6VTQ
You'll get free 60 song credits.
https://sms.napster.com/ns/registration/standard/create_account.html
Create an account and enter the code
CUST57VT6VTQ
You'll get free 60 song credits.
Tuesday, February 23, 2010
Thursday, February 11, 2010
Wednesday, February 3, 2010
$15 off $15 at The Limited
The coupon is for $50 off $150, OR $30 off $100 or $15 off $15. Good from 2/1/2010 ~ 2/10/2010
Linky
Linky
Friday, January 29, 2010
restaurant.com 80% off coupon
Right now you can get $25 worth of gift certificate for only $2 on restaurant.com using the code at the checkout
code: BONUS
Note: there are a lot of restrictions on the use of gift certificate (min charges, 18% tip, one gc per month etc), but at 80% off it's not too bad.
code: BONUS
Note: there are a lot of restrictions on the use of gift certificate (min charges, 18% tip, one gc per month etc), but at 80% off it's not too bad.
Thursday, January 28, 2010
Free Federal e-file for everyone!
Despite the limitation listed on irs website about free federal e-file, TaxAct now offers free fed e-file for everyone. No limitations and from what I can see, it also includes investment/capital gain/loss stuff. Not bad for getting your money back quickly for free.
Online version
Download version
Online version
Download version
Wednesday, January 27, 2010
Visual basic Chr() function in C#
In VB/VB6 we have a function chr(int). To get same results in C# do
Convert.ToChar(int)
Convert.ToChar(int)
Friday, January 22, 2010
Everybody's Free to Wear Sunscreen!
A song I heard on the radio more than 10 years ago. I like to think this song as sort of "guide to life" and it has been one of my favorite songs ever.
Thursday, January 21, 2010
Tuesday, January 19, 2010
Lowes.com 10% off OR $10 off $50 coupon
10% OFF code: MOVER10
$10 off $50 code: LOWES50
Free shipping code: FREESHIP
All in upper case. One code per order.
$10 off $50 code: LOWES50
Free shipping code: FREESHIP
All in upper case. One code per order.
Wednesday, January 13, 2010
sql subquery: select from results from another select statement
To select values from results returned by another select statement we can use the following syntax
Select * from
(select..from..where..) x
The x at the end is the table alias representing the results from the (select..from..where) statement. Without this we get errors like
Incorrect syntax near ')'.
Select * from
(select..from..where..) x
The x at the end is the table alias representing the results from the (select..from..where) statement. Without this we get errors like
Incorrect syntax near ')'.
Tuesday, January 12, 2010
Mystic Lake Casino Buffet buy one get one free or 50% off one
Good until 1/31/10. Not valid on Wednesday seafood night (shame!), but otherwise good value. Coupon is available on their website but I put a printable pdf here anyway.
Coupon Linky
Coupon Linky
Subscribe to:
Comments (Atom)