Nike Factory Outlet - Printable 20% off coupon 3/18 - 3/21

Linky

20% off, good from 3/18~3/21. There's an outlet store at Albertville outlet.

K-mart $10 off $20 printable coupon

Linky

Good until 5/15/10

Gap, Banana Republic, Old Navy - Friends and Family Event 3/18-3/21 30% off

Sign up for an invite here

Linky

Or just print from here

Linky 2

Multiple use. Good for outlet stores too.

Good from 3/18/10 to 3/21/10.

Staples 15% off in-store coupon

Linky

expires 3/23/10

Scott's Fertilizer Coupons - Printable -

$2.50 off 5K and $5.00 off 10K and 15K valid through 9/1/2010

Just in time for spring!

Linky

Best buy 12% off coupon (Exp. 3/21/10)

Linky

Good from 3/10/10 to 3/21/10.

Borders 40% off a single book and 30% off any item

40% off a single book (exp 3/7/09)

30% off any single item (exp 3/8/09)

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.

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.