mAvEriCk ArTs Inc - DoTA,SEO,Internet Marketing

The Dark Knight Rises: Official Batman Movie Trailer 2012

David Beckham baby Harper 7 Beckham on Facebook & Twitter

Harper Seven Beckham

ELECOLDXHOT (ECX) - 8TV Showdown 2011 Final Champion!!

8TV Final Showdown 2011 Dance Crew Champion ELECOLDXHOT (ECX)

Bruno Mars – Marry You Original Live & Glee Cast Cover Version Lyrics

Music: Bruno Mars – Marry You Original Live & Glee Cast Version + Lyrics

Bank of America Routing Number FAQs

Transformers Robot Parade - Autobots vs. Decepticons

Crazy Funny Volkswagen Commercial Star Wars The Force

HotWheels Danicar Loose Photos Danica Patrick Concept Car

How to format datetime and date in Microsoft SQL Server

Higher by Taio Cruz ft. Kylie Minogue MTV & Lyrics

Potential Company Mergers

Iphone Applegirl vs Drummer Girl - Poker Face Battle!

PJLightHouse.com is on the move...

FREE E-bay Paypal MoneySaving Promo Codes Discount Coupons

Top Ten Google SEO Ranking Factors

Warcraft III DotA All-Stars v6.64 AI Map Free Download

Amazingly Cool Bread Art at BreadArtProject.com

Amazingly Cool Cute Little Baby Sculptures

King of Pop Michael Jackson Dead at 50

Terry Fox Run - Never Give Up on a Dream

Inspirational Canadian Terrance Stanley "Terry" Fox

Dangerous VapoRub for children

What is Internet Marketing??

Birds, Animals and Trees Amaze you!

How to Create Select Drop Down list with different font and background color

SQL Server Function to Determine a Leap Year

Sony Computer Entertainment - Playstation 9

Weekly Quote - Freedom, Entrepreneurism & Enthusiasm

DotA: WoWt DotA All-stars v6.52d Map

SQL Tips: Calculating Mathematical Values in SQL Server

BMW GINA Light Visionary Photos

Cool Stuff: Shanghai REN (Human) Iconic Building

Amazing Japanese Food Art

How to Optimize for Google: Part 1 of 3

Cool Cars - Honda CR-Z Cool Concept Car

You are so Beautiful by Joe Cocker

Cool Bear, Horse & Bull Driftwood Sculptures by Matt Torrens

Health: Knee pains

Former The A-Team,Mr. T brings coma boy back to conscious

Love Music: Because I’m A Girl by KISS MTV & Lyrics

SBREAD opening at The Gardens Mid Valley

2 in one day!!

HEALTH RISKS - EFFECTS OF COLD WATER

Patric Chan - Niche Marketing 2.0

Some great ads photo - breaking glasses!

Debunking SEO Mythology by By Matt Foster

mAvEriCk ArTs Inc - DoTA,SEO,Internet Marketing

The Dark Knight Rises: Official Batman Movie Trailer 2012

David Beckham baby Harper 7 Beckham on Facebook & Twitter

Harper Seven Beckham

ELECOLDXHOT (ECX) - 8TV Showdown 2011 Final Champion!!

Bruno Mars – Marry You Original Live & Glee Cast Cover Version Lyrics

Bank of America Routing Number FAQs

Transformers Robot Parade - Autobots vs. Decepticons

Crazy Funny Volkswagen Commercial Star Wars The Force

HotWheels Danicar Loose Photos Danica Patrick Concept Car

How to format datetime and date in Microsoft SQL Server

Higher by Taio Cruz ft. Kylie Minogue MTV & Lyrics

Potential Company Mergers

Iphone Applegirl vs Drummer Girl - Poker Face Battle!

PJLightHouse.com is on the move...

FREE E-bay Paypal MoneySaving Promo Codes Discount Coupons

Top Ten Google SEO Ranking Factors

Warcraft III DotA All-Stars v6.64 AI Map Free Download

Amazingly Cool Bread Art at BreadArtProject.com

Amazingly Cool Cute Little Baby Sculptures

King of Pop Michael Jackson Dead at 50

Terry Fox Run - Never Give Up on a Dream

Inspirational Canadian Terrance Stanley "Terry" Fox

Dangerous VapoRub for children

What is Internet Marketing??

Birds, Animals and Trees Amaze you!

How to Create Select Drop Down list with different font and background color

SQL Server Function to Determine a Leap Year

Sony Computer Entertainment - Playstation 9

Weekly Quote - Freedom, Entrepreneurism & Enthusiasm

DotA: WoWt DotA All-stars v6.52d Map

SQL Tips: Calculating Mathematical Values in SQL Server

BMW GINA Light Visionary Photos

Cool Stuff: Shanghai REN (Human) Iconic Building

Amazing Japanese Food Art

How to Optimize for Google: Part 1 of 3

Cool Cars - Honda CR-Z Cool Concept Car

You are so Beautiful by Joe Cocker

Cool Bear, Horse & Bull Driftwood Sculptures by Matt Torrens

Health: Knee pains

Former The A-Team,Mr. T brings coma boy back to conscious

Love Music: Because I’m A Girl by KISS MTV & Lyrics

SBREAD opening at The Gardens Mid Valley

2 in one day!!

HEALTH RISKS - EFFECTS OF COLD WATER

Patric Chan - Niche Marketing 2.0

Some great ads photo - breaking glasses!

Debunking SEO Mythology by By Matt Foster

Movie: The Dark Knight Rises: Official Batman Teaser Trailer 2012

Music: Higher – Taio Cruz ft. Kylie Minogue MTV & Lyrics

Join PayPal for FREE

Art: Amazing Bread Art at www.breadartproject.com

Amazingly Cool Cute Little Baby Sculptures

Legendary King of Pop Michael Jackson Dead at 50

Health: Don’t use VapoRub on Children under 2

Cool Stuff: Sony Playstation 9

Quotes of the Week - Freedom, Entrepreneurism & Enthusiasm

DotA: World of Warcraft DotA Allstars v6.52d Map Download Link

Cool Stuff: Shanghai REN (Human) Iconic Building

Amazing Japanese Food Art

Cool Stuff: Honda CR-Z Cool Concept Car

Cool Bear, Horse & Bull Driftwood Sculptures by Matt Torrens

Music: Because I’m A Girl by KISS a very Touching Love Story

Get the Facts

Increasing Your Odds

Join PayPal for FREE

Get the Facts

Increasing Your Odds

What is the ABA routing number?

What is the routing number for my Bank of America account?

What if my state has more than one routing number?

What state should I select if I opened my account online or by mail?

Where is the Bank of America transit/ABA routing number on my check?

What is the Automated Clearing House (ACH) number?

DotA: WOW DotA All-Stars v6.52d Map Free Download Link

What is the ABA routing number?

What is the routing number for my Bank of America account?

How do I know which ABA routing number to use?

What if my state has more than one routing number?

What state should I select if I opened my account online or by mail?

What is my routing number if I opened my account through a military bank?

Where is the Bank of America transit/ABA routing number on my check?

What is the Automated Clearing House (ACH) number?

People don’t really understand that there are many different factors that fall into place when determining where a website ranks in the Google search engine results. Some things to keep in mind when you are wondering why your site doesn’t rank well. It is not always just the obvious reasons that are holding it back.

Over the past years by reading Google’s Webmaster Guidelines, Google SEO Starter Guide, many other industry blogs and by actually doing professional SEO and internet marketing since the late 1990’s, I have gathered data and come to a boiled down short list of the most important Google search engine ranking factors.

Here is the list of my top 10 of important Google SEO ranking factors to consider:

1. Age of Domain: Age of URL is very important. If you just bought your domain a few weeks or even months ago you have a long road ahead of you. The reality is the age of your website helps build trust. If your website has been online for several years, chances are you have an established business.

2. Domain Hosting: Where is your site hosted? Find out through your hosting company what continent or country your site is hosted in. This can often times play a large role in search rankings. Always use a reputable hosting company. If your company is US based then use a hosting company in the United States. Also, I always recommend a dedicated IP when you can. There are virtual dedicated and cloud hosting solutions that are more affordable. Never use the cheapest hosting. The reality is, if you cannot afford hosting you should re-consider the business…I know this is harsh but very true. :)

3. Your Neighbors: If you have a virtual server, which sites like Godaddy usually are have been known to house hundreds of websites on one server. Make sure that your neighbors on your server are not classified as spam.

4. URL Structure: Make sure your URL structures are very clean. There should not be any random strings of characters at the end of your URL’s. This is part of the onsite search engine optimization process as well.

5. Content: Content is very important. To start make sure you have text on all your important pages, then make sure it is good text consisting of your targeted keywords spread throughout naturally. Simply put, ALWAYS write your content for humans, your website visitors first and NEVER write content for the solo purpose to achieve Google search engine rankings. Chances are the content will not be user focused or provide value to your visitors.

6. Internal Link Structure: Make sure your inner pages are linked correctly. Visitors should have easy made pathways connecting to your other pages from every page of your website. Make sure the code of your website is verified and keep flash and JavaScript to a minimum, if you can. Essentially make sure the site is clean, easy to use and interlinked to help the user experience.

7. Trust: Do you at least have a mailing address listed on your website? You should if you don’t. Google likes to see trust factors on websites so anything you can add that could help build trust for your audience will benefit your rankings. I always recommend having a phone number on each page of your website. Make it easy for people to do business with you, it all starts with establishing trust and that starts with contact information on your website.

8. Keywords: Make sure your website is optimized using your keywords. This means any alt tags for images, meta page information and existing content at the very least of things. Remember to naturally optimize your website based on the content of each page of your website.

9. Bounce Rate: Although bounce rate might not seem important if Google sees that nobody hangs out on your website for more than a few seconds before they leave this could be a ranking problem over time. Make changes to get visitors engaged with your website. Simple things, like video, newsletter sign up, call to actions, etc will help improve your bounce rate over time. Make sure you have proper tracking on your website, such as Google analytics.

10. Outbound links: Make sure the websites that you link to are 100% relevant to your business and industry. If you sell animals toys but you are linking to a site that sells shoes that is not very relevant and over time could really impact your rankings. Bottom line is if it makes sense to link to another site, then do so, but remember you could be sending your visitors away from your site.

11. Inbound Links: I know this was a list of my top 10, but I felt I had to mention inbound links. The key here (speaking as a white hat SEO person), don’t buy or exchange links. Market and promote your business online to build visitors to your website over time. If you do, then the relevant links will follow!

**Note: As the Google (and yes there are 2 other major search engines!) algorithm changes there are always new ranking factors that come into play, such as the page load time and many others. I am sure when I re-do this list a year from now, there may be another one or two additional factors.

There are many extensive factors that Google uses when determining website rankings. Very important to get these factors correct otherwise you could find yourself just spinning your wheels. The bottom line is it is all about relevancy and earning your visitors (and yes Google’s) search engine trust over time.
Source: www.searchengineoptimizationjournal.com

2011-07-19T19:05:00.000+08:00

The sequel of Batman movie is back with Christian Bale returns as the caped crusader in the new Christopher Nolan‘s film, coming to theaters in summer 2012. Check out the latest official Batman movie trailer, “The Dark Knight Rises" . Watch the movie trailer here >>

2011-07-19T18:57:00.002+08:00

DAVID Beckham looks the proudest dad in the world, as he shows off new daughter Harper Seven for the first time in photos released today.

The black and white shot shows Becks cuddling his new baby who is wrapped up in a white blanket.

Victoria Beckham, 37, posted the photo on Twitter with the caption: "Daddy's little girl".

A second photograph, below, showing new mum Posh and Harper was posted on to David's Facebook page.

The former Spice Girl gave birth on July 10th by caesarean in Los Angeles.
LA Galaxy star David, 36, shed tears of joy when his 7lb 10oz daughter was born.
The footie ace, whose Man Utd and England number was seven, announced the name nine hours after her birth.

He wrote on his Facebook page: "I am so proud and excited to announce the birth of our daughter Harper Seven Beckham. She weighed a healthy 7lb and 10oz.
And in a series of online videos explained: "A lot of thought goes into our children's names and Harper was a name that we've loved for a long time for a couple of reasons."

"One reason is Harper's an old English name which we loved and one of the other reasons was Victoria's favourite book is To Kill A Mockingbird and the author was Harper Lee. It's a very strong, passionate book. That's where Harper came from."
"To have another girl in the family is really incredible. We've got three beautiful healthy boys already and we're so lucky to have that and now to have a beautiful little girl.

"Having a daughter is a whole new thing. Having pink in the house, having lilac in the house... and you have to be a lot more delicate with girls than boys and I'm not used to that so it's a whole new experience."
Yesterday, Becks sported a brand new pair of boots - with the names of his four children printed on one side.

Happy family ... Becks' trainers have his kids names on them

Brooklyn, 12, Romeo, eight, Cruz, six, and Harper all get a mention on the footwear.

He showed off his new trainers at a match in Los Angeles California.

LA Galaxy played against Real Madrid, who won the match 4-1.

It was the first time Beckham has come up against his old side since moving to the United States in 2007

Last week Posh gushed in a Twitter post: "Baby Harper is the most beautiful baby girl I have ever seen. We all feel so blessed and the boys love their baby sister so much!!! X VB."
They have agreed that Harper will be their last child.
A wise move as otherwise Becks would need to get bigger boots...

The Beckhams' firstborn, Brooklyn, was allegedly named after the New York borough where he was conceived, so it's possible that Romeo and Cruz's little sister is called after the times mum and dad did the business.

Cruel wags suggest that Harper might also be named after David's favourite Marx brother "because Groucher didn't sound right", but it's more likely that the name is a tribute to novelist Harper Lee (she wrote To Kill A Mockingbird) and to David's old squad number.

Source: http://www.thesun.co.uk/sol/homepage/showbiz/bizarre/3699482/First-photographs-of-David-and-Victorias-new-baby-girl-Harper-Seven-Beckham.html

2011-07-07T18:18:00.001+08:00

SHAH ALAM: Five-member Elecoldxhot danced their way into the hearts of the audience at 8TV's Showdown 2011 finale at i-City, Shah Alam last night, taking home a cool RM50,000.
Comprising Ooi Kok Wei, Yin Zhen Huang, Yap Jin Hou, Ang Joo Yee and Lin Yit Zhou, they emerged victorious in the final battle against HMC Phlow.

"We came to win, and we're glad all our efforts over the past six months paid off, so it was all worth it," said Yin.Ooi chipped in: "We are thinking of competing at international level with our target being the World Hip-Hop Dance Championship."

Elecoldxhot will be taking a week off to enjoy their hard-earned prize money.

Yin added: "We will definitely have a good holiday, now that we are each richer by RM10,000."
Mixing dance moves influenced by American superstars Justin Timberlake and the late Michael Jackson to South Korean sensation Rain, the Elecoldxhot quintet were clearly a cut above the other dance finalists, namely, HMC Phlow, Rokusteps and Bounce Stepperz.

Elecoldxhot convincingly won with their every performance, and delivered their best choreography during songs like In For The Kill (by British duo La Roux) and Welcome To My Hood (by American trio DJ Khaled, T-Pain and Busta Rhymes).

Rokusteps was eliminated after the first round for having the least text votes.

Next to leave was Bounce Stepperz after their stellar performance failed to garner enough votes for the final face-off.

Showdown 2011 was hosted by radio channel Fly FM deejay Hafiz Hatim and also featured performances by past Showdown winners, with Floor Fever partnering Lee Lessm, and GBC teaming up with JB Breakerz.

Watch all ECX amazing dance clips here >>

2011-05-11T18:12:00.000+08:00

Check out one of my favorite Bruno Mars song, “Marry You”

loving the Glee version more!!!

Enjoy both version plus some of Bruno Mars’s Marry You live version

Click link below to view both the version >>

2011-04-11T18:02:00.032+08:00

The ABA routing number is a 9–digit number assigned to financial institutions by The American Bankers Association (ABA) to identify the financial institution upon which a payment was drawn. Routing numbers are sometimes referred to as “check routing numbers”, “ABA numbers”, or “routing transit numbers” (RTN). Routing numbers may differ depending on where your account was opened and the type of transaction made.

Routing numbers depend on the type of transaction made. Please sign in to Online Banking and click on the Show Routing Numbers link on the Accounts Details page to find your routing numbers (available for all states except Florida, Illinois, Missouri and Texas). If your account was opened in Florida, Illinois, Missouri or Texas, or you do not have access to Online Banking, please contact customer service by calling 1.800.432.1000 to get your routing numbers. Customer service associates are available Monday through Friday from 7 a.m. to 10 p.m.; Saturday and Sunday from 8 a.m. to 5 p.m., local time.

You may also find the correct routing number for the type of transaction you want to make by using the dropdown menu and choosing the state in which your account was opened.

Sample Bank of America Routing Number:

California, North
Paper (ex. Ordering Checks):	121000358
Electronic (ex. Direct Deposit/Automatic Payment):	121000358
Wire Transfer:	026009593

State:California, South
Paper (ex. Ordering Checks):	122000661
Electronic (ex. Direct Deposit/Automatic Payment):	121000358
Wire Transfer:	026009593

How do I know which ABA routing number to use?
Routing numbers depend on the type of transaction made. To reorder checks, use the number for paper transactions. To set up direct deposits (e.g., to receive paychecks or IRS refunds) or outgoing payments to other financial institutions, use the number for electronic transactions. To receive incoming domestic or international wire transfers, use the number for wire transfers.

In California, Illinois, Florida, Missouri, and Texas, there are multiple processing regions, so more information may be needed to determine the routing number for your account. Customer service associates are available to help you identify the correct routing number. Please contact customer service at 1.800.432.1000 (California customers call 1.800.622.8731). Customer service associates are available Monday through Friday from 7 a.m. to 10 p.m., and Saturday and Sunday from 8 a.m. to 5 p.m., local time.

Please sign in to Online Banking and click on the Show Routing Numbers link on the Accounts Details page to find your routing numbers (available for all states except Florida, Illinois, Missouri and Texas). If your account was opened in Florida, Illinois, Missouri or Texas, you do not have access to Online Banking or you do not know the state in which your account was opened, please contact customer service by calling 1.800.432.1000 to get your routing numbers. Customer service associates are available Monday through Friday from 7 a.m. to 10 p.m.; Saturday and Sunday from 8 a.m. to 5 p.m., local time.

What is my routing number if I opened my account through a military bank?
If you opened your account through a military bank, a customer service associate can help you identify the correct routing number. Please contact customer service at 1.800.334.1920 Monday through Friday 7 a.m. to midnight ET and Saturday 10 a.m. to 4 p.m. ET.

The sample check graphic below shows where the ABA routing number can be found on your checks.

If you do not have checks, please use the dropdown menu above to choose the state of the banking center where you opened your account or sign in to Online Banking and click on the Show Routing Numbers link on the Accounts Details page to find your routing numbers (available for all states except Florida, Illinois, Missouri and Texas).

If you opened your account online or by mail, please contact customer service at 1.800.432.1000 (California customers call 1.800.622.8731, Washington and Idaho customers call 1.800.442.6680). Customer service associates are available Monday through Friday from 7 a.m. to 10 p.m. and Saturday and Sunday from 8 a.m. to 5 p.m., local time.

For ACH transactions, please use the routing number for electronic transactions.

The Automated Clearing House (ACH) is an electronic payment delivery system which allows you to make payments or collect funds electronically through the ACH network. We can help you take advantage of the speed and efficiency of electronic payments and collections available through the ACH network, giving you better control over the timing of payments that post to your bank account(s). ACH transactions are usually next-day entries when exchanged with other financial institutions. ACH functions include direct deposits and check conversions from paper to electronic.

Source: http://www.bankofamerica.com/

2011-03-09T13:42:00.000+08:00

Transformers Robot Parade - Autobots vs. Decepticons

2011-02-15T02:47:00.000+08:00

A very funny Volkswagen TV Commercial which features a pint-sized Darth Vader who uses the Force when he discovers the all-new 2012 Passat in the driveway. It leverages humor and the unforgettable Star Wars™ score to create an emotional commercial. Check out the clip below >> Volkswagen Commercial Star Wars The Force

2011-01-02T22:31:00.002+08:00

Feast your eyes on the latest loose DANICAR 2011 Hot Wheels car from Mattel.. The amazing concept car specially designed according to Danica Patrick imagination..

2011 Hot Wheels Danicar side view

View more here >> Hot Wheels Danica Patrick Concept Car - myMatchboxClub.com

2011-01-01T15:04:00.000+08:00

Execute the following Microsoft SQL Server T-SQL datetime and date formatting scripts in Management Studio Query Editor to demonstrate the multitude of temporal data formats available in SQL Server.

First we start with the conversion options available for sql datetime formats with century (YYYY or CCYY format). Subtracting 100 from the Style (format) number will transform dates without century (YY). For example Style 103 is with century, Style 3 is without century. The default Style values – Style 0 or 100, 9 or 109, 13 or 113, 20 or 120, and 21 or 121 – always return the century (yyyy) format.

– Microsoft SQL Server T-SQL date and datetime formats

– Date time formats – mssql datetime

– MSSQL getdate returns current system date and time in standard internal format

SELECT convert(varchar, getdate(), 100) – mon dd yyyy hh:mmAM (or PM)

– Oct 2 2008 11:01AM

SELECT convert(varchar, getdate(), 101) – mm/dd/yyyy - 10/02/2008

SELECT convert(varchar, getdate(), 102) – yyyy.mm.dd – 2008.10.02

SELECT convert(varchar, getdate(), 103) – dd/mm/yyyy

SELECT convert(varchar, getdate(), 104) – dd.mm.yyyy

SELECT convert(varchar, getdate(), 105) – dd-mm-yyyy

SELECT convert(varchar, getdate(), 106) – dd mon yyyy

SELECT convert(varchar, getdate(), 107) – mon dd, yyyy

SELECT convert(varchar, getdate(), 108) – hh:mm:ss

SELECT convert(varchar, getdate(), 109) – mon dd yyyy hh:mm:ss:mmmAM (or PM)

– Oct 2 2008 11:02:44:013AM

SELECT convert(varchar, getdate(), 110) – mm-dd-yyyy

SELECT convert(varchar, getdate(), 111) – yyyy/mm/dd

SELECT convert(varchar, getdate(), 112) – yyyymmdd

SELECT convert(varchar, getdate(), 113) – dd mon yyyy hh:mm:ss:mmm

– 02 Oct 2008 11:02:07:577

SELECT convert(varchar, getdate(), 114) – hh:mm:ss:mmm(24h)

SELECT convert(varchar, getdate(), 120) – yyyy-mm-dd hh:mm:ss(24h)

SELECT convert(varchar, getdate(), 121) – yyyy-mm-dd hh:mm:ss.mmm

SELECT convert(varchar, getdate(), 126) – yyyy-mm-ddThh:mm:ss.mmm

– 2008-10-02T10:52:47.513

– SQL create different date styles with t-sql string functions

SELECT replace(convert(varchar, getdate(), 111), ‘/’, ‘ ‘) – yyyy mm dd

SELECT convert(varchar(7), getdate(), 126) – yyyy-mm

SELECT right(convert(varchar, getdate(), 106), 8) – mon yyyy

————

– SQL Server date formatting function – convert datetime to string

————

– SQL datetime functions

– SQL Server date formats

– T-SQL convert dates

– Formatting dates sql server

CREATE FUNCTION dbo.fnFormatDate (@Datetime DATETIME, @FormatMask VARCHAR(32))

RETURNS VARCHAR(32)

BEGIN

DECLARE @StringDate VARCHAR(32)

SET @StringDate = @FormatMask

IF (CHARINDEX (‘YYYY’,@StringDate) > 0)

SET @StringDate = REPLACE(@StringDate, ‘YYYY’,

DATENAME(YY, @Datetime))

IF (CHARINDEX (‘YY’,@StringDate) > 0)

SET @StringDate = REPLACE(@StringDate, ‘YY’,

RIGHT(DATENAME(YY, @Datetime),2))

IF (CHARINDEX (‘Month’,@StringDate) > 0)

SET @StringDate = REPLACE(@StringDate, ‘Month’,

DATENAME(MM, @Datetime))

IF (CHARINDEX (‘MON’,@StringDate COLLATE SQL_Latin1_General_CP1_CS_AS)>0)

SET @StringDate = REPLACE(@StringDate, ‘MON’,

LEFT(UPPER(DATENAME(MM, @Datetime)),3))

IF (CHARINDEX (‘Mon’,@StringDate) > 0)

SET @StringDate = REPLACE(@StringDate, ‘Mon’,

LEFT(DATENAME(MM, @Datetime),3))

IF (CHARINDEX (‘MM’,@StringDate) > 0)

SET @StringDate = REPLACE(@StringDate, ‘MM’,

RIGHT(’0′+CONVERT(VARCHAR,DATEPART(MM, @Datetime)),2))

IF (CHARINDEX (‘M’,@StringDate) > 0)

SET @StringDate = REPLACE(@StringDate, ‘M’,

CONVERT(VARCHAR,DATEPART(MM, @Datetime)))

IF (CHARINDEX (‘DD’,@StringDate) > 0)

SET @StringDate = REPLACE(@StringDate, ‘DD’,

RIGHT(’0′+DATENAME(DD, @Datetime),2))

IF (CHARINDEX (‘D’,@StringDate) > 0)

SET @StringDate = REPLACE(@StringDate, ‘D’,

DATENAME(DD, @Datetime))

RETURN @StringDate

END

– Microsoft SQL Server date format function test

– MSSQL formatting dates

SELECT dbo.fnFormatDate (getdate(), ‘MM/DD/YYYY’) – 01/03/2012

SELECT dbo.fnFormatDate (getdate(), ‘DD/MM/YYYY’) – 03/01/2012

SELECT dbo.fnFormatDate (getdate(), ‘M/DD/YYYY’) – 1/03/2012

SELECT dbo.fnFormatDate (getdate(), ‘M/D/YYYY’) – 1/3/2012

SELECT dbo.fnFormatDate (getdate(), ‘M/D/YY’) – 1/3/12

SELECT dbo.fnFormatDate (getdate(), ‘MM/DD/YY’) – 01/03/12

SELECT dbo.fnFormatDate (getdate(), ‘MON DD, YYYY’) – JAN 03, 2012

SELECT dbo.fnFormatDate (getdate(), ‘Mon DD, YYYY’) – Jan 03, 2012

SELECT dbo.fnFormatDate (getdate(), ‘Month DD, YYYY’) – January 03, 2012

SELECT dbo.fnFormatDate (getdate(), ‘YYYY/MM/DD’) – 2012/01/03

SELECT dbo.fnFormatDate (getdate(), ‘YYYYMMDD’) – 20120103

SELECT dbo.fnFormatDate (getdate(), ‘YYYY-MM-DD’) – 2012-01-03

– CURRENT_TIMESTAMP returns current system date and time in standard internal format

SELECT dbo.fnFormatDate (CURRENT_TIMESTAMP,‘YY.MM.DD’) – 12.01.03

————

/***** SELECTED SQL DATE/DATETIME FORMATS WITH NAMES *****/

– SQL format datetime

– Default format: Oct 23 2006 10:40AM

SELECT [Default]=CONVERT(varchar,GETDATE(),100)

– US-Style format: 10/23/2006

SELECT [US-Style]=CONVERT(char,GETDATE(),101)

– ANSI format: 2006.10.23

SELECT [ANSI]=CONVERT(char,CURRENT_TIMESTAMP,102)

– UK-Style format: 23/10/2006

SELECT [UK-Style]=CONVERT(char,GETDATE(),103)

– German format: 23.10.2006

SELECT [German]=CONVERT(varchar,GETDATE(),104)

– ISO format: 20061023

SELECT ISO=CONVERT(varchar,GETDATE(),112)

– ISO8601 format: 2008-10-23T19:20:16.003

SELECT [ISO8601]=CONVERT(varchar,GETDATE(),126)

————

– SQL Server datetime formats

– Century date format MM/DD/YYYY usage in a query

– Format dates SQL Server 2005

SELECT TOP (1)

SalesOrderID,

OrderDate = CONVERT(char(10), OrderDate, 101),

OrderDateTime = OrderDate

FROM AdventureWorks.Sales.SalesOrderHeader

/* Result

SalesOrderID OrderDate OrderDateTime

43697 07/01/2001 2001-07-01 00:00:00.000

– SQL update datetime column

– SQL datetime DATEADD

UPDATE Production.Product

SET ModifiedDate=DATEADD(dd,1, ModifiedDate)

WHERE ProductID = 1001

– MM/DD/YY date format

– Datetime format sql

SELECT TOP (1)

SalesOrderID,

OrderDate = CONVERT(varchar(8), OrderDate, 1),

OrderDateTime = OrderDate

FROM AdventureWorks.Sales.SalesOrderHeader

ORDER BY SalesOrderID desc

/* Result

SalesOrderID OrderDate OrderDateTime

75123 07/31/04 2004-07-31 00:00:00.000

– Combining different style formats for date & time

– Datetime formats

– Datetime formats sql

DECLARE @Date DATETIME

SET @Date = ’2015-12-22 03:51 PM’

SELECT CONVERT(CHAR(10),@Date,110) + SUBSTRING(CONVERT(varchar,@Date,0),12,8)

– Result: 12-22-2015 3:51PM

– Microsoft SQL Server cast datetime to string

SELECT stringDateTime=CAST (getdate() as varchar)

– Result: Dec 29 2012 3:47AM

————

– SQL Server date and time functions overview

————

– SQL Server CURRENT_TIMESTAMP function

– SQL Server datetime functions

– local NYC – EST – Eastern Standard Time zone

– SQL DATEADD function – SQL DATEDIFF function

SELECT CURRENT_TIMESTAMP – 2012-01-05 07:02:10.577

– SQL Server DATEADD function

SELECT DATEADD(month,2,’2012-12-09′) – 2013-02-09 00:00:00.000

– SQL Server DATEDIFF function

SELECT DATEDIFF(day,’2012-12-09′,’2013-02-09′) – 62

– SQL Server DATENAME function

SELECT DATENAME(month, ’2012-12-09′) – December

SELECT DATENAME(weekday, ’2012-12-09′) – Sunday

– SQL Server DATEPART function

SELECT DATEPART(month, ’2012-12-09′) – 12

– SQL Server DAY function

SELECT DAY(’2012-12-09′) – 9

– SQL Server GETDATE function

– local NYC – EST – Eastern Standard Time zone

SELECT GETDATE() – 2012-01-05 07:02:10.577

– SQL Server GETUTCDATE function

– London – Greenwich Mean Time

SELECT GETUTCDATE() – 2012-01-05 12:02:10.577

– SQL Server MONTH function

SELECT MONTH(’2012-12-09′) – 12

– SQL Server YEAR function

SELECT YEAR(’2012-12-09′) – 2012

————

– T-SQL Date and time function application

– CURRENT_TIMESTAMP and getdate() are the same in T-SQL

————

– SQL first day of the month

– SQL first date of the month

– SQL first day of current month – 2012-01-01 00:00:00.000

SELECT DATEADD(dd,0,DATEADD(mm, DATEDIFF(mm,0,CURRENT_TIMESTAMP),0))

– SQL last day of the month

– SQL last date of the month

– SQL last day of current month – 2012-01-31 00:00:00.000

SELECT DATEADD(dd,-1,DATEADD(mm, DATEDIFF(mm,0,CURRENT_TIMESTAMP)+1,0))

– SQL first day of last month

– SQL first day of previous month – 2011-12-01 00:00:00.000

SELECT DATEADD(mm,-1,DATEADD(mm, DATEDIFF(mm,0,CURRENT_TIMESTAMP),0))

– SQL last day of last month

– SQL last day of previous month – 2011-12-31 00:00:00.000

SELECT DATEADD(dd,-1,DATEADD(mm, DATEDIFF(mm,0,DATEADD(MM,-1,GETDATE()))+1,0))

– SQL first day of next month – 2012-02-01 00:00:00.000

SELECT DATEADD(mm,1,DATEADD(mm, DATEDIFF(mm,0,CURRENT_TIMESTAMP),0))

– SQL last day of next month – 2012-02-28 00:00:00.000

SELECT DATEADD(dd,-1,DATEADD(mm, DATEDIFF(mm,0,DATEADD(MM,1,GETDATE()))+1,0))

– SQL first day of a month – 2012-10-01 00:00:00.000

DECLARE @Date datetime; SET @Date = ’2012-10-23′

SELECT DATEADD(dd,0,DATEADD(mm, DATEDIFF(mm,0,@Date),0))

– SQL last day of a month – 2012-03-31 00:00:00.000

DECLARE @Date datetime; SET @Date = ’2012-03-15′

SELECT DATEADD(dd,-1,DATEADD(mm, DATEDIFF(mm,0,@Date)+1,0))

– SQL first day of year

– SQL first day of the year - 2012-01-01 00:00:00.000

SELECT DATEADD(yy, DATEDIFF(yy,0,CURRENT_TIMESTAMP), 0)

– SQL last day of year

– SQL last day of the year – 2012-12-31 00:00:00.000

SELECT DATEADD(yy,1, DATEADD(dd, -1, DATEADD(yy,

DATEDIFF(yy,0,CURRENT_TIMESTAMP), 0)))

– SQL last day of last year

– SQL last day of previous year – 2011-12-31 00:00:00.000

SELECT DATEADD(dd,-1,DATEADD(yy,DATEDIFF(yy,0,CURRENT_TIMESTAMP), 0))

– SQL calculate age in years, months, days

– SQL table-valued function

– SQL user-defined function – UDF

– SQL Server age calculation – date difference

– Format dates SQL Server 2008

USE AdventureWorks2008;

CREATE FUNCTION fnAge (@BirthDate DATETIME)

RETURNS @Age TABLE(Years INT,

Months INT,

Days INT)

BEGIN

DECLARE @EndDate DATETIME, @Anniversary DATETIME

SET @EndDate = Getdate()

SET @Anniversary = Dateadd(yy,Datediff(yy,@BirthDate,@EndDate),@BirthDate)

INSERT @Age

SELECT Datediff(yy,@BirthDate,@EndDate) - (CASE

WHEN @Anniversary > @EndDate THEN 1

ELSE 0

END), 0, 0

UPDATE @Age SET Months = Month(@EndDate - @Anniversary) - 1

UPDATE @Age SET Days = Day(@EndDate - @Anniversary) - 1

RETURN

END

– Test table-valued UDF

SELECT * FROM fnAge(’1956-10-23′)

SELECT * FROM dbo.fnAge(’1956-10-23′)

/* Results

Years Months Days

52 4 1

———-

– SQL date range between

———-

– SQL between dates

USE AdventureWorks;

– SQL between

SELECT POs=COUNT(*) FROM Purchasing.PurchaseOrderHeader

WHERE OrderDate BETWEEN ’20040301′ AND ’20040315′

– Result: 108

– BETWEEN operator is equivalent to >=…AND….<=

SELECT POs=COUNT(*) FROM Purchasing.PurchaseOrderHeader

WHERE OrderDate

BETWEEN ’2004-03-01 00:00:00.000′ AND ’2004-03-15 00:00:00.000′

Orders with OrderDates

’2004-03-15 00:00:01.000′ – 1 second after midnight (12:00AM)

’2004-03-15 00:01:00.000′ – 1 minute after midnight

’2004-03-15 01:00:00.000′ – 1 hour after midnight

are not included in the two queries above.

– To include the entire day of 2004-03-15 use the following two solutions

SELECT POs=COUNT(*) FROM Purchasing.PurchaseOrderHeader

WHERE OrderDate >= ’20040301′ AND OrderDate < ’20040316′

– SQL between with DATE type (SQL Server 2008)

SELECT POs=COUNT(*) FROM Purchasing.PurchaseOrderHeader

WHERE CONVERT(DATE, OrderDate) BETWEEN ’20040301′ AND ’20040315′

———-

– Non-standard format conversion: 2011 December 14

– SQL datetime to string

SELECT [YYYY Month DD] =

CAST(YEAR(GETDATE()) AS VARCHAR(4))+ ‘ ‘+

DATENAME(MM, GETDATE()) + ‘ ‘ +

CAST(DAY(GETDATE()) AS VARCHAR(2))

– Converting datetime to YYYYMMDDHHMMSS format: 20121214172638

SELECT replace(convert(varchar, getdate(),111),‘/’,”) +

replace(convert(varchar, getdate(),108),‘:’,”)

– Datetime custom format conversion to YYYY_MM_DD

select CurrentDate=rtrim(year(getdate())) + ‘_’ +

right(’0′ + rtrim(month(getdate())),2) + ‘_’ +

right(’0′ + rtrim(day(getdate())),2)

– Converting seconds to HH:MM:SS format

declare @Seconds int

set @Seconds = 10000

select TimeSpan=right(’0′ +rtrim(@Seconds / 3600),2) + ‘:’ +

right(’0′ + rtrim((@Seconds % 3600) / 60),2) + ‘:’ +

right(’0′ + rtrim(@Seconds % 60),2)

– Result: 02:46:40

– Test result

select 2*3600 + 46*60 + 40

– Result: 10000

– Set the time portion of a datetime value to 00:00:00.000

– SQL strip time from date

– SQL strip time from datetime

SELECT CURRENT_TIMESTAMP ,DATEADD(dd, DATEDIFF(dd, 0, CURRENT_TIMESTAMP), 0)

– Results: 2014-01-23 05:35:52.793 2014-01-23 00:00:00.000

/*******

VALID DATE RANGES FOR DATE/DATETIME DATA TYPES

SMALLDATETIME date range:

January 1, 1900 through June 6, 2079

DATETIME date range:

January 1, 1753 through December 31, 9999

DATETIME2 date range (SQL Server 2008):

January 1,1 AD through December 31, 9999 AD

DATE date range (SQL Server 2008):

January 1, 1 AD through December 31, 9999 AD

*******/

– Selecting with CONVERT into different styles

– Note: Only Japan & ISO styles can be used in ORDER BY

SELECT TOP(1)

Italy = CONVERT(varchar, OrderDate, 105)

, USA = CONVERT(varchar, OrderDate, 110)

, Japan = CONVERT(varchar, OrderDate, 111)

, ISO = CONVERT(varchar, OrderDate, 112)

FROM AdventureWorks.Purchasing.PurchaseOrderHeader

ORDER BY PurchaseOrderID DESC

/* Results

Italy USA Japan ISO

25-07-2004 07-25-2004 2004/07/25 20040725

– SQL Server convert date to integer

DECLARE @Datetime datetime

SET @Datetime = ’2012-10-23 10:21:05.345′

SELECT DateAsInteger = CAST (CONVERT(varchar,@Datetime,112) as INT)

– Result: 20121023

– SQL Server convert integer to datetime

DECLARE @intDate int

SET @intDate = 20120315

SELECT IntegerToDatetime = CAST(CAST(@intDate as varchar) as datetime)

– Result: 2012-03-15 00:00:00.000

————

– SQL Server CONVERT script applying table INSERT/UPDATE

————

– SQL Server convert date

– Datetime column is converted into date only string column

USE tempdb;

CREATE TABLE sqlConvertDateTime (

DatetimeCol datetime,

DateCol char(8));

INSERT sqlConvertDateTime (DatetimeCol) SELECT GETDATE()

UPDATE sqlConvertDateTime

SET DateCol = CONVERT(char(10), DatetimeCol, 112)

SELECT * FROM sqlConvertDateTime

– SQL Server convert datetime

– The string date column is converted into datetime column

UPDATE sqlConvertDateTime

SET DatetimeCol = CONVERT(Datetime, DateCol, 112)

SELECT * FROM sqlConvertDateTime

– Adding a day to the converted datetime column with DATEADD

UPDATE sqlConvertDateTime

SET DatetimeCol = DATEADD(day, 1, CONVERT(Datetime, DateCol, 112))

SELECT * FROM sqlConvertDateTime

– Equivalent formulation

– SQL Server cast datetime

UPDATE sqlConvertDateTime

SET DatetimeCol = DATEADD(dd, 1, CAST(DateCol AS datetime))

SELECT * FROM sqlConvertDateTime

DROP TABLE sqlConvertDateTime

/* First results

DatetimeCol DateCol

2014-12-25 16:04:15.373 20141225 */

/* Second results:

DatetimeCol DateCol

2014-12-25 00:00:00.000 20141225 */

/* Third results:

DatetimeCol DateCol

2014-12-26 00:00:00.000 20141225 */

————

– SQL month sequence – SQL date sequence generation with table variable

– SQL Server cast string to datetime – SQL Server cast datetime to string

– SQL Server insert default values method

DECLARE @Sequence table (Sequence int identity(1,1))

DECLARE @i int; SET @i = 0

DECLARE @StartDate datetime;

SET @StartDate = CAST(CONVERT(varchar, year(getdate()))+

RIGHT(’0′+convert(varchar,month(getdate())),2) + ’01′ AS DATETIME)

WHILE ( @i < 120)

BEGIN

INSERT @Sequence DEFAULT VALUES

SET @i = @i + 1

END

SELECT MonthSequence = CAST(DATEADD(month, Sequence,@StartDate) AS varchar)

FROM @Sequence

/* Partial results:

MonthSequence

Jan 1 2012 12:00AM

Feb 1 2012 12:00AM

Mar 1 2012 12:00AM

Apr 1 2012 12:00AM

————

– SQL Server Server datetime internal storage

– SQL Server datetime formats

————

– SQL Server datetime to hex

SELECT Now=CURRENT_TIMESTAMP, HexNow=CAST(CURRENT_TIMESTAMP AS BINARY(8))

/* Results

Now HexNow

2009-01-02 17:35:59.297 0x00009B850122092D

– SQL Server date part – left 4 bytes – Days since 1900-01-01

SELECT Now=DATEADD(DAY, CONVERT(INT, 0x00009B85), ’19000101′)

– Result: 2009-01-02 00:00:00.000

– SQL time part – right 4 bytes – milliseconds since midnight

– 1000/300 is an adjustment factor

– SQL dateadd to Midnight

SELECT Now=DATEADD(MS, (1000.0/300)* CONVERT(BIGINT, 0x0122092D), ’2009-01-02′)

– Result: 2009-01-02 17:35:59.290

————

– String date and datetime date&time columns usage

– SQL Server datetime formats in tables

————

USE tempdb;

SET NOCOUNT ON;

– SQL Server select into table create

SELECT TOP (5)

FullName=convert(nvarchar(50),FirstName+‘ ‘+LastName),

BirthDate = CONVERT(char(8), BirthDate,112),

ModifiedDate = getdate()

INTO Employee

FROM AdventureWorks.HumanResources.Employee e

INNER JOIN AdventureWorks.Person.Contact c

ON c.ContactID = e.ContactID

ORDER BY EmployeeID

– SQL Server alter table

ALTER TABLE Employee ALTER COLUMN FullName nvarchar(50) NOT NULL

ALTER TABLE Employee

ADD CONSTRAINT [PK_Employee] PRIMARY KEY (FullName )

/* Results

Table definition for the Employee table

Note: BirthDate is string date (only)

CREATE TABLE dbo.Employee(

FullName nvarchar(50) NOT NULL PRIMARY KEY,

BirthDate char(8) NULL,

ModifiedDate datetime NOT NULL

)

SELECT * FROM Employee ORDER BY FullName

/* Results

FullName BirthDate ModifiedDate

Guy Gilbert 19720515 2009-01-03 10:10:19.217

Kevin Brown 19770603 2009-01-03 10:10:19.217

Rob Walters 19650123 2009-01-03 10:10:19.217

Roberto Tamburello 19641213 2009-01-03 10:10:19.217

Thierry D’Hers 19490829 2009-01-03 10:10:19.217

– SQL Server age

SELECT FullName, Age = DATEDIFF(YEAR, BirthDate, GETDATE()),

RowMaintenanceDate = CAST (ModifiedDate AS varchar)

FROM Employee ORDER BY FullName

/* Results

FullName Age RowMaintenanceDate

Guy Gilbert 37 Jan 3 2009 10:10AM

Kevin Brown 32 Jan 3 2009 10:10AM

Rob Walters 44 Jan 3 2009 10:10AM

Roberto Tamburello 45 Jan 3 2009 10:10AM

Thierry D’Hers 60 Jan 3 2009 10:10AM

– SQL Server age of Rob Walters on specific dates

– SQL Server string to datetime implicit conversion with DATEADD

SELECT AGE50DATE = DATEADD(YY, 50, ’19650123′)

– Result: 2015-01-23 00:00:00.000

– SQL Server datetime to string, Italian format for ModifiedDate

– SQL Server string to datetime implicit conversion with DATEDIFF

SELECT FullName,

AgeDEC31 = DATEDIFF(YEAR, BirthDate, ’20141231′),

AgeJAN01 = DATEDIFF(YEAR, BirthDate, ’20150101′),

AgeJAN23 = DATEDIFF(YEAR, BirthDate, ’20150123′),

AgeJAN24 = DATEDIFF(YEAR, BirthDate, ’20150124′),

ModDate = CONVERT(varchar, ModifiedDate, 105)

FROM Employee

WHERE FullName = ‘Rob Walters’

ORDER BY FullName

/* Results

Important Note: age increments on Jan 1 (not as commonly calculated)

FullName AgeDEC31 AgeJAN01 AgeJAN23 AgeJAN24 ModDate

Rob Walters 49 50 50 50 03-01-2009

————

– SQL combine integer date & time into datetime

————

– Datetime format sql

– SQL stuff

DECLARE @DateTimeAsINT TABLE ( ID int identity(1,1) primary key,

DateAsINT int,

TimeAsINT int

)

– NOTE: leading zeroes in time is for readability only!

INSERT @DateTimeAsINT (DateAsINT, TimeAsINT) VALUES (20121023, 235959)

INSERT @DateTimeAsINT (DateAsINT, TimeAsINT) VALUES (20121023, 010204)

INSERT @DateTimeAsINT (DateAsINT, TimeAsINT) VALUES (20121023, 002350)

INSERT @DateTimeAsINT (DateAsINT, TimeAsINT) VALUES (20121023, 000244)

INSERT @DateTimeAsINT (DateAsINT, TimeAsINT) VALUES (20121023, 000050)

INSERT @DateTimeAsINT (DateAsINT, TimeAsINT) VALUES (20121023, 000006)

SELECT DateAsINT, TimeAsINT,

CONVERT(datetime, CONVERT(varchar(8), DateAsINT) + ‘ ‘+

STUFF(STUFF ( RIGHT(REPLICATE(’0′, 6) + CONVERT(varchar(6), TimeAsINT), 6),

3, 0, ‘:’), 6, 0, ‘:’)) AS DateTimeValue

FROM @DateTimeAsINT

ORDER BY ID

/* Results

DateAsINT TimeAsINT DateTimeValue

20121023 235959 2012-10-23 23:59:59.000

20121023 10204 2012-10-23 01:02:04.000

20121023 2350 2012-10-23 00:23:50.000

20121023 244 2012-10-23 00:02:44.000

20121023 50 2012-10-23 00:00:50.000

20121023 6 2012-10-23 00:00:06.000

————

– SQL Server string to datetime, implicit conversion with assignment

UPDATE Employee SET ModifiedDate = ’20150123′

WHERE FullName = ‘Rob Walters’

SELECT ModifiedDate FROM Employee WHERE FullName = ‘Rob Walters’

– Result: 2015-01-23 00:00:00.000

/* SQL string date, assemble string date from datetime parts */

– SQL Server cast string to datetime – sql convert string date

– SQL Server number to varchar conversion

– SQL Server leading zeroes for month and day

– SQL Server right string function

UPDATE Employee SET BirthDate =

CONVERT(char(4),YEAR(CAST(’1965-01-23′ as DATETIME)))+

RIGHT(’0′+CONVERT(varchar,MONTH(CAST(’1965-01-23′ as DATETIME))),2)+

RIGHT(’0′+CONVERT(varchar,DAY(CAST(’1965-01-23′ as DATETIME))),2)

WHERE FullName = ‘Rob Walters’

SELECT BirthDate FROM Employee WHERE FullName = ‘Rob Walters’

– Result: 19650123

– Perform cleanup action

DROP TABLE Employee

– SQL nocount

SET NOCOUNT OFF;

————

– sql isdate function

————

USE tempdb;

– sql newid – random sort

SELECT top(3) SalesOrderID,

stringOrderDate = CAST (OrderDate AS varchar)

INTO DateValidation

FROM AdventureWorks.Sales.SalesOrderHeader

ORDER BY NEWID()

SELECT * FROM DateValidation

/* Results

SalesOrderID stringOrderDate

56720 Oct 26 2003 12:00AM

73737 Jun 25 2004 12:00AM

70573 May 14 2004 12:00AM

– SQL update with top

UPDATE TOP(1) DateValidation

SET stringOrderDate = ‘Apb 29 2004 12:00AM’

– SQL string to datetime fails without validation

SELECT SalesOrderID, OrderDate = CAST (stringOrderDate as datetime)

FROM DateValidation

/* Msg 242, Level 16, State 3, Line 1

The conversion of a varchar data type to a datetime data type resulted in an

out-of-range value.

– sql isdate – filter for valid dates

SELECT SalesOrderID, OrderDate = CAST (stringOrderDate as datetime)

FROM DateValidation

WHERE ISDATE(stringOrderDate) = 1

/* Results

SalesOrderID OrderDate

73737 2004-06-25 00:00:00.000

70573 2004-05-14 00:00:00.000

– SQL drop table

DROP TABLE DateValidation

————

– SELECT between two specified dates – assumption TIME part is 00:00:00.000

————

– SQL datetime between

– SQL select between two dates

SELECT EmployeeID, RateChangeDate

FROM AdventureWorks.HumanResources.EmployeePayHistory

WHERE RateChangeDate >= ’1997-11-01′ AND

RateChangeDate < DATEADD(dd,1,’1998-01-05′)

/* Results

EmployeeID RateChangeDate

3 1997-12-12 00:00:00.000

4 1998-01-05 00:00:00.000

/* Equivalent to

– SQL datetime range

SELECT EmployeeID, RateChangeDate

FROM AdventureWorks.HumanResources.EmployeePayHistory

WHERE RateChangeDate >= ’1997-11-01 00:00:00′ AND

RateChangeDate < ’1998-01-06 00:00:00′

————

– SQL datetime language setting

– SQL Nondeterministic function usage – result varies with language settings

SET LANGUAGE ‘us_english’; –– Jan 12 2015 12:00AM

SELECT US = convert(VARCHAR,convert(DATETIME,’01/12/2015′));

SET LANGUAGE ‘British’; –– Dec 1 2015 12:00AM

SELECT UK = convert(VARCHAR,convert(DATETIME,’01/12/2015′));

SET LANGUAGE ‘German’; –– Dez 1 2015 12:00AM

SET LANGUAGE ‘Deutsch’; –– Dez 1 2015 12:00AM

SELECT Germany = convert(VARCHAR,convert(DATETIME,’01/12/2015′));

SET LANGUAGE ‘French’; –– déc 1 2015 12:00AM

SELECT France = convert(VARCHAR,convert(DATETIME,’01/12/2015′));

SET LANGUAGE ‘Spanish’; –– Dic 1 2015 12:00AM

SELECT Spain = convert(VARCHAR,convert(DATETIME,’01/12/2015′));

SET LANGUAGE ‘Hungarian’; –– jan 12 2015 12:00AM

SELECT Hungary = convert(VARCHAR,convert(DATETIME,’01/12/2015′));

SET LANGUAGE ‘us_english’;

————

– Function for Monday dates calculation

————

USE AdventureWorks2008;

– SQL user-defined function

– SQL scalar function – UDF

CREATE FUNCTION fnMondayDate

(@Year INT,

@Month INT,

@MondayOrdinal INT)

RETURNS DATETIME

BEGIN

DECLARE @FirstDayOfMonth CHAR(10),

@SeedDate CHAR(10)

SET @FirstDayOfMonth = convert(VARCHAR,@Year) + ‘-’ + convert(VARCHAR,@Month) + ‘-01′

SET @SeedDate = ’1900-01-01′

RETURN DATEADD(DD,DATEDIFF(DD,@SeedDate,DATEADD(DD,(@MondayOrdinal * 7) - 1,

@FirstDayOfMonth)) / 7 * 7, @SeedDate)

END

– Test Datetime UDF

– Third Monday in Feb, 2015

SELECT dbo.fnMondayDate(2016,2,3)

– 2015-02-16 00:00:00.000

– First Monday of current month

SELECT dbo.fnMondayDate(Year(getdate()),Month(getdate()),1)

– 2009-02-02 00:00:00.000

2011-01-01T11:57:00.000+08:00

check out this hot song from Taio Cruz featuring Kylie Minogue in “Higher“. view music video here >>

2010-12-10T11:49:00.002+08:00

Xerox and Wurlitzer: They're going to make reproductive organs

Fairchild Electronics and Honeywell Computers: New company will be called Fairwell Honeychild

3M and Goodyear: New company will be called mmmGood

Polygram records, Warner Brothers and Keebler: new company will be called Poly Warner Cracker

W.R. Grace Co., Fuller Brush Co., Mary Kay Cosmetics and Hale Business Systems: New company will be called Hale Mary Fuller Grace

John Deere and Abitibi-Price: new company will be called Deere Abi

Honeywell, Imasco, and Home Oil: New company will be called Honey I'm Home

Denison Mines, Alliance and Metal Mining: New company will be called Mine, All Mine

3M, J.C. Penney and Canadian Opera Company: New company will be called 3 Penney Opera

Knott's Berry Farm and National organization of Women: New company will be called Knott NOW!

Zippo Manufacturing, Audi, Dofasco, and Dakota Mining: New company will be called Zip Audi Do-Da

2010-07-10T18:12:00.000+08:00

Check this Poker Face Battle !! who do you think win ?

Iphone Applegirl vs Drummer Girl :) Watch and be amazed!!

Click Here to Continue Reading..

2010-02-25T11:28:00.005+08:00

hi guys, if you are looking for pjlighthouse.com , sorry to inform you that it will be down temporarily due to some problem with godaddy hosting. Please be patient at the moment till I can get things sorted out. In meantime you can visit the backup of some post here. You can leave a comment or feedback if you need any info. Thanks !

2010-02-25T10:36:00.005+08:00

Here's a method that can help you save money (about 3% OFF) when you purchase on eBay.com, eBay.ca and eBay.co.uk!

Get up to 3% off cash back on any products purchased (Auctions or Buy it now) on eBay.com, eBay.ca & eBay.co.uk - The world’s most popular online store!

No Minimum Purchase Required!

Fast email reply on any questions. Feel free to contact us on any questions so we can build up trust! Full Refund if you are not satisfied!

There is NO minimum purchase required

Use it online at eBay.com, eBay.ca & eBay.co.uk

There is no limit on how many times you can use this discount

Read this before you purchase on eBay. Otherwise you will not get the discount!

The discount will be paid as cash back. Like a rebate.

This is NOT eBay coupon and it is stackable with eBay coupon if eBay send you one. (eBay coupon is not transferrable. You can only use eBay coupon if eBay sends you the coupon code.)

A great potential to earn residual income!

It’s so Simple… Here’s how: Join FREE and start earning cash back today!

2010-02-15T14:34:00.001+08:00

2010-01-19T01:22:00.002+08:00

Best Download for Warcraft III DotA All-Stars 6.64 AI Map!
Download Free AI Maps links below
Warcraft III DotA v6.64 (v0.213) Map Changelog:
-First update to v6.64
-Changed the default AI behaviour of creeps and towers to be the same as in the official map
-Fixed the fade on Circles of Protection belonging to other players
-Fixed some numerical errors on Bristleback’s abilities
-Added some additional AI ability functionality (Black Hole, Fissure, Epicenter)Free Map download here >> Free Warcraft III DotA v6.64 AI Map Download

2009-10-22T16:46:00.001+08:00

Check out these very amazing BreadArt that I stumbled upon at www.breadartproject.com. The Bread ART PROJECT was created by the Grain Foods Foundation to help increase awareness of the growing hunger problem in the United Statevery amazing!! see more bread art here >>

2009-09-22T16:49:00.000+08:00

Check out some of these amazingly cute baby culpture :) see more cute more Little Baby Sculptures here >>

2009-06-29T04:00:00.004+08:00

Shocking news!!! Michael Jackson is dead due to cardiac arrest on Thursday 3:15 p.m. 18th June 2009. Music icon Michael Jackson, whose fame spanned from his childhood with the legendary Jackson 5 to a superstar solo career that earned him the nickname ‘King of Pop‘ died Thursday afternoon at a Los Angeles hospital, a source close to the family told FOX News. He was 50 years old.

Read more here >>

2009-05-25T14:25:00.000+08:00

Tribute music video to Terry Fox who attempted to run across Canada on one leg, a victim of cancer. Terry died before completing his run.

In June 1981, Terry developed pneumonia, and on June 27, he went into a coma. He died on the 28th at 4:35 a.m., which was his favourite hour of running, a year after his legendary run, and exactly one month shy of his twenty-third birthday.

Song is by Rod Stewart, which was written and recorded as a tribute to Terry. Videos obtained from CBC web archives. Images of cancer patients obtained through Google image searches

2009-05-25T14:14:00.000+08:00

Terrance Stanley "Terry" Fox, CC (July 28, 1958 – June 28, 1981) was a Canadian humanitarian, athlete, and cancer treatment activist. He became famous for the Marathon of Hope, a cross-Canada run to raise money for cancer research, which Fox ran with one prosthetic leg. He is considered one of Canada's greatest heroes of the 20th century and is celebrated internationally every September as people participate in the Terry Fox Run, the world's largest one-day fundraiser for cancer research.

Terry Fox in Toronto during his Marathon of Hope cross-country run (July 1980).

Source: http://en.wikipedia.org/wiki/Terry_Fox

2009-02-21T09:41:00.000+08:00

2 health articles on VapoRub usage on children under two years old.. Take precautions when you use this medicine. See more details articles >>

Tags: Haelth, Danger, Vicks, Article, News, Danger to Baby, Parenting, Health Hazard, Chemical, Flu, Influenza, Pharmaceutical, VapoRub, Child care, Doctor

2008-10-23T12:12:00.000+08:00

What is Internet Marketing??

Internet marketing is still a complete mystery to a large majority of Internet users. For many users, internet marketing is seen as some foreign area of the web, populated with silly get-rich-quick schemes and unsavory characters ready to rip off the innocent and uninformed consumer at the click of a mouse. Continue to read more.. SEO: 5 Most Popular Forms of Internet Marketing

2008-10-02T09:24:00.001+08:00

Here's some amazing facts about Birds, Animals and Trees amaze you!

1) SNAILS have 14175 teeth laid along 135 rows on their tongue.

2) A BUTTERFLY has 12,000 eyes.

3) DOLPHINS sleep with 1 eye open.

4) A BLUE WHALE can eat as much as 3 tonnes of food everyday, but at the same time can live without food for 6 months.

5) ELEPHANT teeth can weigh as much as 9 pounds.

6) The fierce DINOSAUR was TRYNOSAURS which has sixty long & sharp teeth, used to attack & eat other dinosaurs.

7) DIMETRODON was a mammal like REPTILE with a snail on its back. This acted as a radiator to cool the body of the animal.

8) CASSOWARY is one of the dangerous BIRD, that can kill a man or animal by tearing off with its dagger like claw.

Read more here : Cool & Amazing World Facts

2008-08-14T09:27:00.000+08:00

Here's some useful codes to create drop down list to create dropdown list with font and background color in HTML :)

Paste code below in between your HEAD tags

Paste code below in between your BODY tags

2008-07-12T10:47:00.000+08:00

Problem
I need to write a function to determine if particular year is a leap year (i.e. February contains 29 days rather than 28 days). I know that there are various rules for calculating leap years. Is there an easy way to figure this out? Can you provide an example or two to validate various years?

Solution
Yes, there a few rules to consider when determining when a year is a leap year. For instance, contrary to popular belief not all years divisible by 4 are leap years. For instance, the year 1900 was not a leap year. However, you needn't bother yourself about leap year rules... you can let the SQL Server engine do the work for you!

The following scalar function takes in a year and returns a bit flag indicating whether the passed in year is a leap year or not.

create function dbo.fn_IsLeapYear (@year int)
returns bit
as
begin
return(select case datepart(mm, dateadd(dd, 1, cast((cast(@year as varchar(4)) + '0228') as datetime)))
when 2 then 1
else 0
end)
end
go

That's all there is to it! The function takes in the year, appends '0228' to it (for February 28th) and adds a day. If the month of the next day is a 2 (as extracted by the DATEPART function), then we're still in February so it must be a leap year! If not, it is not a leap year.

Here are a few examples:

select dbo.fn_IsLeapYear(1900) as 'IsLeapYear?'
select dbo.fn_IsLeapYear(2000) as 'IsLeapYear?'
select dbo.fn_IsLeapYear(2007) as 'IsLeapYear?'
select dbo.fn_IsLeapYear(2008) as 'IsLeapYear?'

As you can see, sometimes you can leverage the SQL Server engine to do some heavy lifting for you!

2008-07-05T04:57:00.000+08:00

A superb cool advertisement from Sony Computer Entertainment for their Playstation 9 (PS9), which the company claims will be released in year 2078. Watch the video here see what the future holds >>

2008-07-04T21:23:00.000+08:00

FREEDOM
“We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain unalienable Rights that among these are Life, Liberty and the pursuit of Happiness.” ~The Declaration of Independence
“In order to live free and happily you must sacrifice boredom. It is not always an easy sacrifice.” ~Richard Bach
Posterity! You will never know how much it cost the present generation to preserve your freedom! I hope you will make good use of it! (letter to Abigail Adams, April 26, 1777) ~John Adams
“These are the times that try men’s souls. The summer soldier and the sunshine patriot will, in this crisis, shrink from the service of their country; but he that stands it now, deserves the love and thanks of man and woman.” ~Thomas Paine
Read more ..

2008-07-03T04:55:00.000+08:00

Check out the Latest World Of Wwarcraft Dota-Allstars map is out.. here’s the change logs and download links of DotA v6.52d map at the end of the post .. Enjoy the maps download here >>

2008-06-24T10:08:00.000+08:00

Problem
In our application we have the need to perform mathematical calculations. Right now we are doing so in our front end application. Unfortunately we are starting to experience performance problems with large data sets and differences in calculations due to developers using different logic. We are seeking some other options to perform the calculations. Does SQL Server perform basic mathematical calculations?

Solution
Yes - SQL Server can perform basic addition, subtraction, multiplication and division. So if you need some of those basic building blocks those are available and we will walk through some examples in this tip. In addition, SQL Server can calculate SUM, COUNT, AVG, etc. For these type of calculations, check out SQL Server T-SQL Aggregate Functions. To address the multiple code issues, I would recommend researching stored procedures. This tip Getting started with SQL Server stored procedures is probably a good place to start.

In this tip, let's focus on some basic building blocks to perform your calculations with the T-SQL language. Here are the examples we will cover:

Calculations on Values
Calculations on Parameters
Calculations on Columns
Calculations in Computed Columns

Calculations on Values

As a starting point, values themselves can have mathematical operations performed on them. So in the code below we are performing addition (+), subtraction (-), multiplication (*), division (/) and a combination of operations. In these examples, both positive and negative whole numbers and decimals are used. The value calculated by the statement is below the code to serve as a point of reference. Review and copy the code into a SQL Server 2005 Management Studio window to get a feel for these calculations. Certainly this list is not comprehensive, so feel free to test some operations in your applications or from your experiences.

Calculations on Values

-- Example 1 - Addition (+)

SELECT 1 + 1
-- = 2

SELECT 1 + 2 + 3 + 4 + 99 + 704
-- = 813

SELECT 1.5 + 1.5
-- = 3.0

SELECT .25678 + .00096356
-- = 0.25774356

SELECT 1.75 + -2.25
-- = -0.50

-- Example 2 - Subtraction (-)

SELECT 1 - 1
-- = 0

SELECT 918 - 704
-- = 214

SELECT 3.2 - 1.9
-- = 1.3

SELECT 1.9 - 3.2
-- = -1.3

SELECT 9 - 3 - 3
-- = 3

SELECT .75 - .68
-- = 0.07

-- Example 3 - Multiplication (*)

SELECT 1 * 1
-- = 1

SELECT 2 * -4
-- = -8

SELECT 2 * 5 * 10
-- = 100

SELECT 1.25 * 3
-- = 3.75

SELECT .4 * .5
-- = .20

-- Example 4 - Division (/)

SELECT 1/2
-- = 0

SELECT 1.0/2.0
-- = 0.500000

SELECT 0/5
-- = 0

SELECT 100/12
-- = 8

SELECT 100.0/12.0
-- = 8.333333

SELECT -75.0/4.5
-- = -16.666666

SELECT .5/.1
-- = 5.000000

-- Example 5 - Combination

SELECT ((100 + 100) * .05)
-- = 10.00

SELECT (10 - 5)/2
-- = 2

SELECT (10.0 - 5.0)/2.0
-- = 2.500000

SELECT ((100 + 100) - (50 + 50))
-- = 100

Calculations on Parameters

Since we have covered the bulk of the calculations in the section above let's just focus on a few different operations to show how parameters with specific data types play an important role. Since this set of examples are not comprehensive, feel free to copy the code below into a SQL Server 2005 Management Studio window and test the code with some of your own logic.

Calculations on Parameters

-- Variable declaration
DECLARE @i1 int
DECLARE @i2 int
DECLARE @i3 int
DECLARE @d1 decimal(10,2)
DECLARE @d2 decimal(10,2)
DECLARE @d3 decimal(10,2)

-- Initialize variables
SET @i1 = 100
SET @i2 = 75
SET @i3 = 50
SET @d1 = 1.5
SET @d2 = 5.5
SET @d3 = .575

-- Example 1 - Addition (+)
SELECT @i1 + @i2 + @i3 + @d1 + @d2 + @d3
-- = 232.58

SELECT @d2 + -@d3
-- = 4.92

-- Example 2 - Subtraction (-)
SELECT @i2 - @i3
-- = 25

SELECT @d2 - @d3
-- = 4.92

-- Example 3 - Multiplication (*)
SELECT @i2 * @i3
-- = 3750

SELECT @d2 * @d3
-- = 3.1900

-- Example 4 - Division (/)
SELECT @i2 / @i3
-- = 1

SELECT @d2 / @d3
-- = 9.4827586206896

-- Example 5 - Combination
SELECT ((@i1 + @i2) * @d2)
-- = 962.50

SELECT ((@i1 + @i2) - (@d1 + @d2))
-- = 168.00

Calculations on Columns

Another option is to calculate the values based on a SELECT statement as the example below shows. If the data is in 1 or more columns, this approach eliminates the need to calculate the values based on additional parameters or logic.

Calculations on Columns

-- Sample Table
CREATE TABLE dbo.CalculationExample(
ProductID int NOT NULL,
Cost decimal(10,2) NOT NULL)
GO

-- Populate Table
INSERT INTO dbo.CalculationExample (ProductID, Cost)
SELECT 1, 100.00
UNION
SELECT 2, 50.00
UNION
SELECT 3, 25.00
GO

-- Verify Insertion
SELECT *
FROM dbo.CalculationExample
GO

-- Declare Variables
DECLARE @MarginPercent decimal(10, 2)
DECLARE @TaxPercent decimal(10, 2)

-- Initialize Variables
SET @MarginPercent = .20
SET @TaxPercent = .05

-- Calculate Values
SELECT ProductID,
Cost,
Cost * @MarginPercent AS 'Margin',
Cost * @TaxPercent AS 'Tax',
Cost + (Cost * @MarginPercent) + (Cost * @TaxPercent) AS 'FinalCost'
FROM dbo.CalculationExample
GO

Calculations in Computed Columns

Let's take those same calculations and now move them to computed columns in the table. Here is that example:

Calculations in Computed Columns

CREATE TABLE [dbo].[CalculationExample_ComputedColumns](
[ProductID] [int] NOT NULL,
[Cost] [decimal](18, 0) NOT NULL,
[Tax] AS ([Cost]*(0.05)),
[Margin] AS ([Cost]*(0.20)),
[FinalCost] AS (([Cost]+[Cost]*(0.20))+[Cost]*(0.05)),
CONSTRAINT [PK_CalculationExample_ComputedColumns] PRIMARY KEY CLUSTERED
(
[ProductID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

-- Populate Table
INSERT INTO dbo.CalculationExample_ComputedColumns (ProductID, Cost)
SELECT 1, 100.00
UNION
SELECT 2, 50.00
UNION
SELECT 3, 25.00
GO

-- Review the values
SELECT *
FROM dbo.CalculationExample_ComputedColumns
GO

2008-06-07T05:01:00.000+08:00

The BMW GINA (Geometry and Functions in ‘N’ Adaptations) Light Visionary concept is BMW’s future-focused design study on the possibilities offered by flexible coverings. Based on a 2-seater roadster platform, GINA’s revolutionary exterior has allowed its designers to do away with the traditional body panel approach, concentrating on visual and structural lines rather than full body pieces. Check out more photos >> Cool Stuff: BMW GINA (Geometry and Functions in ‘N’ Adaptations) Light Visionary Photos

2008-05-14T19:45:00.000+08:00

REN = = Human in Chinese.. This is one awesome Architecture!!! See more of this amazing future skyscraper in China.. See more pics here >>

2008-04-24T12:13:00.002+08:00

These are some creative food art.. japanese rice art.

2008-04-23T12:37:00.000+08:00

In today's online world search engine rankings can make your business succeed, and while rankings in Yahoo and MSN are very valuable, their combined market value is still less than that of Google. This makes achieving top rankings in Google that much more important.

In this three-part series on How to Optimize for Google we will touch on a number of important aspects for top Google rankings including website optimization, links, Google Webmaster tools, and a number of other considerations.

The focus of Part 1 will be with on page website optimization.

THE RIGHT KEYWORDS
This article is not about keyword research so I will not spend too much time on this topic, however, I felt it was important to at least brush on this slightly. If you are interested in reading more, please see Keyword Research for Organic SEO.

Make sure that your targets are achievable. If you select the wrong keywords, it can make your entire optimization experience essentially a waste. Choose keywords that are attainable but yet still provide a reasonable search frequency for your industry. Your phrase selection should also be targeted to bring qualified traffic to your site.

Using the hotel industry as an example, targeting the word "hotel" would make very little sense but by narrowing it down to "Victoria BC hotel" you now have less competition, and a more qualified audience. Keep your targets in perspective and go after the obtainable rankings.

WEBSITE OPTIMIZATION
There are many on-site factors that play a role in your search engine rankings. Here are a number of those factors and what you can do to increase your chances of success.

Title Tag
The title tag plays one of the most important roles in search results at Google, and is almost always the heading Google chooses for each of its listings. Placement of your target phrase is best used near the start of the tag and repeated again in the middle or near the end. Three uses of your target phrase may be helpful in some instances, as long as it is not too overwhelming. For best results each page on your site should have a totally unique title tag.

It is also important to remember that because Google will use this title as the main heading for your listing, you will want to keep it attractive to potential searchers. Try to also add a call to action, or other wording to help make your listing appear attractive to searchers.

To help illustrate the fact Google takes this tag into consideration, simply do a search for your target phrase and take a look at the titles of the top 10. I tried a search for a rather broad term "hotel" and saw that all 10/10 listings had it in the title tag, and 6/10 had it as the very first word. A quick scan showed that the entire top 30 either had the word hotel, or hotels in their title tags.

If you do only one thing to your website, make sure that all your title tags are relevant, unique, and contain your target phrase for each page.

Meta Description Tag
The Meta Description tag is still occasionally used by Google as the description which appears in the search results themselves. While this used to be a more common practice Google tends to use it most often on sites with very limited content, or those which are flash based. I have seen it still used for content rich sites, however this is less common.

The Meta Description tag still has an impact on search rankings. Your best bet when using this tag is to keep it short and sweet with your target phrase close to the start and not repeated more than 3 times. Like the title tag, each page on your site should have its own unique description tag.

Meta Keyword Tag
When it comes to Google this tag is useless, and won't influence your rankings. There is some speculation as to whether a spammy keyword tag can however, have a negative effect on Google rankings. As a result, if you do utilize a keyword Meta tag for the smaller engines, it is best to keep it clean and play it safe.

Density
Keyword density plays a role in overall rankings; however, it is not as cut and dry as it once was. Once upon a time there was a magic number that when used could almost guarantee top rankings.

This is no longer the case. Today the ideal density varies from industry to industry, phrase to phrase. To find out what density you should aim for, take the top 10 or 20 search results and see what percentage those sites are using. In most cases you will find that the majority of these sites have a very similar density to one another, and this average density is a good estimation of what you should aim for.

Body Text and Keyword Placement
The location of relevant text on your site will help establish the overall importance of your target phrase. While you do not want to overwhelm the engines and site visitors with a bombardment of target phrases at the top of the page, try to sprinkle in some instances as close to the top of the page as possible.

Synonyms
Be sure to include various synonyms for your target phrases within your body text on your site. Google will use these synonyms to tie in the overall relevance of the page for your main target phrases, which in turn can improve your odds.

To find possible synonyms you can use a thesaurus, but the best way is to search Google itself and see exactly what they consider to be similar. Simply search in Google for your target phrase preceded with a tilde, such as "~hotels". Next scan through the search results for any text Google has bolded. These are all words that Google considers to be related. Using the "~hotels" example Google brings up phrases such as 'travel', 'tourism', 'accommodation', as well as various hotel chain names such as 'Hilton Hotels'.

Keywords in Domain
There is still some speculation if having a target phrase as part of your top level domain (TLD) is of use to search rankings. From my experience, yes, there is value here, although, nothing like it was several years ago.

If you are starting off in the online world and are contemplating which domain to go for, consider one that uses your target phrase, assuming that it is both relevant to your business name, and uses no more than a single hyphen. While multiple hyphens in a domain can be successful, they are very common with highly spammy websites, so it is best to not take that route if possible.

While having a keyword located within your domain can provide some ranking juice, I would not suggest heading out and doing a domain swap. In most cases you would be better off working on your existing site than starting from scratch with a new domain.

Keywords in page specific URL
Using keywords for specific page URL's can also help add a little bit of value to your site, providing you use them responsibly. Consider using a keyword as a directory name and as part of a file name where it naturally makes sense to do so. If you have a website that focuses on tourism and includes local hotel listings, you may want to consider the following structure for your page on the Hilton:

MyTourismSite.com/Victoria/Accommodations/Hotels/Hilton.html

Heading Tags
Placement of target phrases within heading tags helps to establish the importance of those given phrases. That said do not over do it, or abuse it. Only place target phrases within a heading tag if it makes sense to do so, and don't flood a page with numerous tags. Heading tags are not as critical as they once were, but still a good contribution to a well optimized page.

Link Anchor text
This is the actual text you clíck on as part of a link. When full or partial target phrases are used within your text links they help pass on some value to the linked page for those phrases. This is also true when considering surrounding text. When the content around the link is also relevant, the link holds slightly more value.

While a link that simply states "clíck here" or "www.domainname.com" does have its place, they provide considerably less value than a link that would use "discount hotels" as its anchor.

Image Alt Text
While image alt text still plays a minor role, its biggest part is within the use of image based navigation. If you have an image linked to another page, the alt text will be attributed much the same way as standard link anchor text is.

Image Alt text should always be short and to the point and should accurately describe either the image itself, or the page the image is linking to. Do not use alt tags as a place to stuff keywords.

Inline Links
These are links that are found mid sentence or mid paragraph as opposed to a simple listing of links as found in a menu or possibly on a sitemap. Links found mid paragraph tend to pass on a little more value from the surrounding text and can provide more relevance to the linked page.

Site Navigation
It is absolutely imperative that your website be fully spiderable by the search engines. This may seem obvious, but often webmasters overlook Google's ability to crawl a website. Google has become very advanced in what links it can follow and how it can spider a website, but there are still some things that can cause significant roadblocks.

- Flash: One of the most commonly made mistakes is the use of flash. If flash is used as a sole means of site navigation then you can count on Google not viewing your internal pages, and having a significant disadvantage in terms of site rankings.

- Java Script / DHTML: These days most Java Script and even DHTML menus can be spidered by Google, however, this is not always the case. If your site utilizes any kind of fancy navigation and you are wondering why Google has not indexed your internal pages, check out Google's Cached Text version of your page. If you do not see any text links, then your navigation may be invisible to Google.

- Images: Image based navigation has been safe for many years now, but if your site uses this form of navigation it is essential to have brief, relevant alt text on all your buttons. This alt text will act much like standard anchor text for text based links. This is not only for the purpose of search ranking value, but take a look at Google's cached text version of your page. If you have image based links that do not have alt text, those links do not appear. This doesn't mean Google won't follow them, but for anyone viewing your site on a text based browser, your links will be invisible to them.

URL Structure
Avoid long elaborate URL's with extraneous characters. While Google has reached a point where they can index massive URL strings, it is best to avoid them if at all possible. For dynamic sites consider utilizing mod rewrites to significantly clean up the URL to not only make it more search engine friendly, but more user friendly as well.

SUMMARY
Basic website optimization is a critical component for successful placement in Google but is only part of the overall picture. Stay tuned for "How to Optimize for Google - Part 2 of 3" where we will discuss Links and Google Webmaster Tools.

About The Author
Scott Van Achte is the Senior SEO at StepForth Web Marketing Inc., based in Victoria, BC, Canada and founded in 1997. You can read more of Scott's articles and those of the StepForth team at news.stepforth.com or contact us at StepForth.com, Tel - 250-385-1190, TollFree - 877-385-5526, Fax - 250-385-1198

2008-04-22T12:10:00.000+08:00

Check out this amazing concept car from Japan.. the Honda CR-Z

2008-04-20T12:08:00.000+08:00

You are so Beautiful Joe. My concert photos in a slideshow tribute to Mr. Cocker. 1999 from Clarkston Michigan.

2008-04-04T04:47:00.000+08:00

Matt Torrens was born and raised in Calgary Alberta, Canada, growing up attending the Greatest Outdoor Show on Earth, the Calgary Stampede, and was inspired by the cowboy way of life. Be sure to check out my next show at the Grand National art show & sale at the Cow Palace in San Francisco, April 4th-12th. See more of his masterpiece below

2008-04-01T04:45:00.000+08:00

What are the functions of the knee?

The knee joint has three parts. The thigh bone (femur) meets the large shin bone (tibia) forming the main knee joint. This joint has an inner (medial) and an outer (lateral) compartment. The kneecap (patella) joins the femur to form a third joint, called the patellofemoral joint.

A joint capsule surrounds the knee joint with ligaments strapping the inside and outside of the joint (collateral ligaments) as well as crossing within the joint (cruciate ligaments). These ligaments provide stability and strength to the knee joint.

The meniscus is a thickened cartilage pad between the two joints formed by the femur and tibia. The meniscus acts as a smooth surface for the joint to move on. Fluid-filled sacs called bursae, which serve as gliding surfaces that reduce friction of the tendons, surround the knee joint. Below the kneecap, there is a large tendon (patellar tendon) that attaches to the front of the tibia bone. The large muscles of the thigh move the knee. The knee also rotates slightly under guidance of specific muscles of the thigh. The knee functions to allow movement of the leg and is critical to normal walking and is a weight-bearing joint.

What injuries can cause knee pain?

An injury can affect any of the ligaments, bursae, or tendons surrounding the knee joint. The complexity of the design of the knee joint and the fact that it is an active weight-bearing joint are factors that make the knee one of the most commonly injured joints.

Ligament Injury

Trauma can cause injury to the ligaments on the inner portion of the knee, the outer portion of the knee or within the knee. Injuries to these areas are noticed as immediate pain, but are sometimes difficult to localise. A collateral ligament injury is often associated with local tenderness over the area of the ligament involved. A ligament injury to the knee is usually painful at rest and may be swollen and warm. The pain can worsen by bending the knee, putting weight on the knee or walking. The severity of the injury can vary from mild (minor stretching or tearing of the ligament fibres, such as a low grade sprain) to severe (complete tear of the ligament fibres). Patients can have more than one area injured in a single traumatic event.

Ligament injuries are initially treated with ice packs and immobilisation, with rest and elevation. It is generally initially recommended to avoid bearing weight on the injured joint and crutches may be required for walking. Some patients are placed in splints or braces to immobilise the joint to decrease pain and promote healing. Arthroscopic or open surgery may be necessary to repair severe injuries.
Meniscus tears

The meniscus can be torn with the shearing forces of rotation that are applied to the knee during sharp, rapid motions. This is especially common in sports requiring reaction body movements. There is a higher incidence with aging and degeneration of the underlying cartilage. More than one tear can be present in an individual meniscus. The patient with a meniscal tear may have a rapid onset of a popping sensation with a certain activity or movement of the knee. Occasionally, it is associated with swelling and warmth in the knee. It is often associated with locking or unstable sensation in the knee joint. The meniscal tear can be diagnosed in one of three ways: arthroscopy, arthrography, or an MRI.
Tendinitis

Tendinitis is an inflammation of the tendon, which is often produced by a strain event, such as jumping. Tendinitis is diagnosed based on the presence of pain and tenderness localised to the tendon. It is treated with a combination of ice packs, immobilisation with a knee brace as needed, rest, and anti-inflammatory medications. In severe cases, surgery may be required. Surgical repair of the ruptured tendon is often necessary.
Fractures

With severe knee trauma, such as motor vehicle accidents, bone breakage (fracture) of any of the three bones of the knee can occur. Bone fractures within the knee joint can be serious and can require surgical repair as well as immobilisation with casting or other supports.

What diseases and conditions can cause knee pain?

Knee pain can also be caused due to diseases or conditions that involve the knee joint, the soft tissues and the bones surrounding the knee, or the nerves that supply sensation to the knee area.

Arthritis is the inflammation within a joint. The causes of knee joint inflammation range from non-inflammatory types of arthritis such as osteoarthritis, which is a degeneration of the cartilage of the knee, to inflammatory types of arthritis (rheumatoid arthritis or gout). Treatment of the various type of arthritis is directed towards the specific type of arthritis.
Chondromalacia refers to the softening of the cartilage under the kneecap (patella). It is a common cause of deep knee pain and stiffness in younger women and can be associated with pain and stiffness after prolonged sitting and climbing stairs or hills. While treatment with anti-inflammatory medications, ice packs, and rest can help, long-term relief is best achieved by strengthening exercises for the muscles of the front of the thigh.
Bursitis of the knee commonly occurs on the inside of the knee and the front of the kneecap. Bursitis is generally treated with ice packs, immobilisation, and anti-inflammatory medications and may require local injections of corticosteroids as well as exercise therapy to develop the musculature of the front of the thigh.
Infections of the bone or joint can rarely be a serious cause of knee pain. They do have associated signs of infection including fever, extreme heat, warmth of the joint, chills of the body, and may be associated with puncture wounds in the area around the knee.
Tumours involving the joint are extremely rare. They can cause problems with local pain.
The collateral ligament on the inside of the knee joint can become calcified and is referred to as Pellegrini-Stieda syndrome. With this condition, the knee can become inflamed and can be treated conservatively with ice packs, immobilisation and rest.

2008-03-25T00:20:00.000+08:00

Former The A-Team star Mr. T once stunned a sick child's family by bringing him out of a coma - after doctors begged the actor for help.

The poorly kid fell unconscious in Detroit, Michigan in the mid-1980s - and the only physical movement he made was in response to hearing Mr. T's name.

And when the mohawked star was in town, he stopped by the hospital to visit the ill boy - with miraculous results.

He tells Empire magazine, "His family put toys around him and one of them was a Mr. T doll. And whenever my name came up, the boy moved his arm.

"Somebody told the doctors I was in town, so they called me down there. I closed the curtains and prayed. Then, as I was walking down the hall, the kid suddenly came out of the coma and hollered out.

"That was my supernatural moment."

2008-03-21T04:52:00.003+08:00

A very touching Love story Music Video by KISS titled “Because I’m A Girl“… must watch! Watch the MTV here... >>

Tags: MTV, Music, Lyrics, Korean, KISS, Pop, Love, Song, Sacrifice, Love Song, Music Video, YouTube, Touching

2008-03-06T15:57:00.003+08:00

SBread is now open at the Gardens Mid Valley in Petaling Jaya..

Check out their promo...

We are now SBREADing at The Gardens Mid Valley, lower ground.
Come down today and taste our original & tasty breads, topped up with
unique recipes of spreads.

Not just another Toast & Kaya coffeeshop...
SBREAD's like no other in Malaysia...

At SBREAD.....
Pick a BREAD (3 special choices)
Pick a SPREAD (9 original delicious recipes)
Complete... with a SBREADVERAGE (check out the "Pink" Barley and Iced Thai Tea)

Original, Tasty and Healthy in every serve. Freshly Made Daily.....

Everyone has a favourite sbread...U just.can't sbread enough!!!

Pls share this with all your friends...Thx many many!

www.sbread.com
facebook: http://www.facebook.com/pages/SBREAD/21445808800

sbread.gardens@gmail.com
t: +603-22832929, f:+603-22832229

2008-03-06T10:36:00.001+08:00

2008-02-28T10:33:00.001+08:00

.
For those who like to drink cold water, this article is applicable to you. It is nice to have a cup of cold drink after a meal. However, the cold water will solidify the oily stuff that you have just consumed. It will slow down the digestion. Once this 'sludge' reacts with the acid, it will break down and be absorbed by the intestine faster than the solid food. It will line the intestine. Very soon, this will turn into fats and lead to cancer. It is best to drink hot soup or warm water after a meal.

A serious note about heart attacks - You should know that not every heart attack symptom is going to be the left arm hurting. Be aware of intense pain in the jaw line.

You may never have the first chest pain during the course of a heart attack. Nausea and intense sweating are also common symptoms. 60% of people who have a heart attack while they are asleep do not wake up. Pain in the jaw can wake you from a sound sleep. Let's be careful and be aware. The more we know the better chance we could survive.

A cardiologist says if everyone who reads this message sends it to 10 people, you can be sure that we'll save at least one life. Read this & Send the link to a friend. It could save a life. So, please be a true friend and send this article to all your friends you care about.
.

2008-02-27T15:08:00.001+08:00

Patric Chan explaining about his new product Niche Marketing 2.0

2008-02-02T20:02:00.000+08:00

2008-01-28T10:01:00.000+08:00

Google especially has cracked down hard on paid links in the last few months. To put it succinctly, they don't pass page rank. If you want to buy a link from a site, only do it if you believe the link itself will be a good source of traffic -- in other words, only do it for legitimate advertising purposes. Do not do it if your purpose is for that link to transfer page rank or increase your ranking, as it likely will not.

In Greek mythology, the Hydra was a creature who could not be defeated, as each time one of its heads was cut off, two more would sprout back in its place. It seems that SEO mythology is no different; every time one SEO myth is debunked, two more SEO myths crop back up in its place, only adding to the confusion about search engine optimization.

Hercules was able to defeat the Hydra by cutting off its heads and then burning the stumps before new heads could grow back. What SEO needs is a hero, an SEO Hercules, to come and save us from the Hydra of SEO Mythology. Let's go through some of the more pervasive SEO myths and see if we can put a torch to them.

Myth: All I need to do is figure out the magic bullet, and I will be at the top of the search engines.

Fact: Search engines use over 200 factors to rank sites. No one factor will get you to the top. To get to the top, you must have a balanced search engine strategy encompassing many factors, both on page and off page. There is no magic bullet.

Myth: Search rankings are about link popularity. Get as many links as you can. Join Web rings, "free for all" (FFA) link exchanges, and get as many sites as you can to link to you through reciprocal linking back to them.

Fact: While link popularity is important if done correctly, Google (Nasdaq: GOOG) is placing links under increasing scrutiny, and sheer volumes of inbound linking without regard to the source of the link and other factors hasn't worked in years. It is not the raw number of links that matter, but the type of links. Links from trusted sites, relevant to your industry, with proper anchor text and relevant surrounding text and page content, to original content on your site are the ones that will help you.

FFA linking will most likely get you in trouble with the engines as they could interpret that as an attempt to spam the results. In addition to bleeding away all of your page rank to other sites, FFA linking will increase your chances of linking to a "bad neighborhood," another thing which can get you into trouble. Never link to sites you do not know or with which you are not familiar. Remember, Google is smarter than you, you can't fool them with unnatural linking schemes.

Myth: It's all about "keyword density." Be sure to repeat your keyword numerous times on your Web site. Keyword repetition increases keyword density and inflates your search engine ranking.

Fact: Structuring your page around some magic formula for key phrase density does nothing for you. Yes, your target key phrases should be included at least once on the page, as well as in your title and meta description elements, and in an H1 or H2 tag if possible. Other than that, forget about key phrase density. Create your Web content for human readers and write it so it makes sense to them. Whatever you do, avoid key phrase repetition, a known spamming technique sure to get you into trouble.

Myth: Repeated submissions to the search engines increase your rankings. It is a good idea to sign up for an automated submission service, which will regularly resubmit your site to 1,000 or more search engines each week.

Fact: Automated submissions are a violation of major search engines' Terms of Inclusion and can get you into trouble. Search engines don't need you to submit to them, set up a blog and get a few links to your site, and they will find you very quickly. Using Blogger.com, which is owned by Google, usually can get a new site indexed within a week. Just be sure to put a link on the blog to your site.

Myth: The meta keywords tag must include your target keywords. Search engines place heavy weight on this tag and use it to determine which keywords for which to rank your site.

Fact: Search engines that matter, such as Google, place zero weight on the keywords meta element due to historical spam. Yahoo appears to give it some small weight. In any event, use of the keyword meta element is of so little use, many SEO's ignore it altogether.

Myth: Because links are so important to search rankings, I should go out and purchase a large number of paid links and submit to hundreds or thousands of directories in order to get more links to my site.

Fact: Google especially has cracked down hard on paid links in the last few months. To put it succinctly, they don't pass page rank. If you want to buy a link from a site, only do it if you believe the link itself will be a good source of traffic (in other words, only do it for legitimate advertising purposes). Do not do it if your purpose is for that link to transfer page rank or increase your ranking, as it likely will not.

Additionally, hundreds of useless directories have been harshly penalized as well, so that links from within them are either not counted at all or given very little weight. Get links from a few well respected directories such as dmoz.org, Yahoo directory, Business.com, JoeAnt and others which have a manual review process. Automated submission services which submit to hundreds of directories are a waste of money.

Myth: I should write articles and submit them to article directories, because links from article directories have high page rank and are given great weight by the engines.

Fact: Article directory links in and of themselves carry little to no weight. The engines are smart and know that people spam these directories with useless content just to get a link. If you want to get relevant, trusted links to your site that actually mean something, create useful, informative, or educational content that people will want to link to. Articles are one form of such content, but only if they are good enough to get picked up by other sites. Other content which can serve as link bait is video content, tools and widgets, product reviews, top 10 lists, and interesting or entertaining blogs.

Alaska

Paper (ex. Ordering Checks):

Electronic (ex. Direct Deposit/Automatic Payment):

Wire Transfer: