10 step to celebrate Christmas!!

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.

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