With no sample(s) of your current data all I can suggest is that you look at using the built in function GETDATE.

For example:

SELECT GETDATE() executing this...

Could this be the article:

Group Islands of Contiguous Dates (SQL Spackle)

By Jeff Moden, 2013/10/04 (first published: 2010/12/07)

http://www.sqlservercentral.com/articles/T-SQL/71550/

Sounds like you should look up the function GETUTCDATE (Transact-SQL) at

http://technet.microsoft.com/en-us/library/ms178635(v=sql.100).aspx

This value represents the current UTC time (Coordinated Universal Time).

+2

Sounds like you are asking for answers to a homework question.

Use GOOGLE to search for your answers. If you do, the following are typical of the answers you will...

+1

Use GOOGLE searching for "weight and height chart" and select from the responses (I got About 27,700,000 results in (0.22 seconds))

Click on the link Result:

Nice question - learned something new today Thanls

There have been times that I've gone to lunch with a group just to build better relationships... I called it work, and in my opinion this falls under the same...

For those that want to hear what I want for Christmas ....

http://www.songfacts.com/detail.php?id=9570

Are you aquatinted with BETWEEN operator available in SQL ?

BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression...

In the left most column of a this page, as you read my response click on the word Stairways and you will be rewarded with a series of links...

Try this site for download

http://www.microsoft.com/en-us/download/details.aspx?id=15748

Swat