1. Plan Christmas - plan your Christmas, the food you want to serve, the gift you want to give. Make a list and go shopping for one day.
2. Decoration – place light and other decoration outside your house. Set up a live or artificial Christmas tree in your house. Decorate it with lights.
3. Wish list – ask your children to write wish list of the things they would like to receive.
4. Music – play Christmas music in your house, in your car and in your office.
5. Card – send Christmas card to family and friends.
6. Huge Dinner – prepare a huge Christmas feast food.(ham, vegetable, pie and etc)
7. Church – Attend to church on Christmas eve
8. Quality time – give yourself a break during the day, the family time together, having fun and enjoying your time.
9. Be thankful – count your blessings, there are millions of people worse off, look around your house, your family. You are truly blessed.
10. Pray – remember the true meaning of Christmas is really about Christ, and about giving.
Rabu, 21 Desember 2011
Rabu, 15 Juni 2011
Sql DateName
Sales Id Customer Id Sales Date Note
S001 C02 2010-05-20 -
S002 C03 2010-03-10 Cash
S003 C01 2010-01-02 -
select datename (weekday,salesdate)as [Tanggal Transaksi] from trans
select datename(dw,salesdate) as [Tanggal Transaksi] from trans
Thursday
Wednesday
Saturday
select datename(day,salesdate) as [Tanggal Transaksi] from trans
select datename(d,salesdate) as [Tanggal Transaksi] from trans
select datename(dd,salesdate)as [Tanggal Transaksi] from trans
20
10
2
select datename(month,salesdate) as [Tanggal Transaksi] from trans
select datename(mm,salesdate) as [Tanggal Transaksi] from trans
select datename(m,salesdate) as [Tanggal Transaksi] from trans
May
March
January
select datename(year,salesdate) as [Tanggal Transaksi] from trans
select datename(yyyy,salesdate) as [Tanggal Transaksi] from trans
select datename(yy,salesdate) as [Tanggal Transaksi] from trans
2010
2010
2010
S001 C02 2010-05-20 -
S002 C03 2010-03-10 Cash
S003 C01 2010-01-02 -
select datename (weekday,salesdate)as [Tanggal Transaksi] from trans
select datename(dw,salesdate) as [Tanggal Transaksi] from trans
Thursday
Wednesday
Saturday
select datename(day,salesdate) as [Tanggal Transaksi] from trans
select datename(d,salesdate) as [Tanggal Transaksi] from trans
select datename(dd,salesdate)as [Tanggal Transaksi] from trans
20
10
2
select datename(month,salesdate) as [Tanggal Transaksi] from trans
select datename(mm,salesdate) as [Tanggal Transaksi] from trans
select datename(m,salesdate) as [Tanggal Transaksi] from trans
May
March
January
select datename(year,salesdate) as [Tanggal Transaksi] from trans
select datename(yyyy,salesdate) as [Tanggal Transaksi] from trans
select datename(yy,salesdate) as [Tanggal Transaksi] from trans
2010
2010
2010
Langganan:
Postingan (Atom)