Staples 10% off in-store coupon

Linky

Valid 12/20~12/26.

Old Navy Printable 30% off Single Item In-Store Coupon

Good until 12/19. Applies to any single item (inc. sales items I believe)

Linky

astraweb yearly special at $96/year ($8/month)

This is an excellent deal for a premium usenet server.Works out to be $8/month which I consider is money well spent and cheaper than most other usenet servers.

Linky

If you don't like paying annually, there's also a deal available for $11/month

 Linky

Best buy 10% off coupon

Valid til 12/14. Good for some last minute Christmas shopping.

Linky

Notes on sql query: sort by date in sql server

I recently encountered this in one of the sql stored procedure I worked on. The query is to select from a table then sort by a date time field.

Select * from Table 1
Order by date

It works fine when all the dates are in the same year, but if there are dates in different year, then we see entries like this

11-26-2008
11-26-2009
12-01-2008
 
For some reason sql server seemed to sort the datetime field by the order of month, day, year. To fix this, we need to change the order by statement to sort the year component first.

Select * from Table 1
Order by year(date), date

or

Select * from Table 1
Order by datepart(year, date), date

The result is now correct
11-26-2008
12-01-2008
11-26-2009

Cheap Sprint phones (Touch Pro2 $50, Hero $30 etc) and 20% discount off plan

Update 12/02/2009

Looks like the deal is now dead. Good luck to those who get in.


Saw this information on Howard Forums and Slickdeals.net and thought I'd pass along the information. I've not personally tried this since I do not want to give up my SERO plan but from the forums it seemed to work. Apparently people are paying $25 on ebay to get this link.

Linky

Some notable phones
Sprint HERO $29.99
Samsung Moment $29.99
HTC Touch Pro2 $49.99

All without rebate. And you also get 20% discount on your monthly bill. Supposedly works for newline and upgrade, 2 yr contract extension is needed.

You should be able to also use code SAVE50 to get $50 credit.