Group dates by quarterly/Half yearly/weekly

Group dates by quarterly/Half yearly/weekly

References

Reference NO 1

http://stackoverflow.com/questions/13585371/group-dates-by-quarterly-half-yearly-weekly

Reference NO 2

http://chandoo.org/wp/2009/11/17/group-dates-in-pivot-tables/

Reference NO 3

http://dss.princeton.edu/online_help/stats_packages/stata/time_series_data.htm

Reference NO 4

http://english.stackexchange.com/questions/105869/whats-the-best-english-word-for-6-months-in-this-group-daily-weekly-quarterl

Reference NO 5

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/53f635a6-7b39-4b26-8d45-6a5efdd0ece7/action?threadDisplayName=group-by-week-month-or-quarter

Reference NO 6

https://www.stanford.edu/group/ssds/cgi-bin/drupal/files/Guides/Working%20with%20Dates%20and%20Times%20in%20Stata.pdf

Reference NO 7

http://www.bigresource.com/MS_SQL-Select-daily-monthly-weekly-quarterly-and-yearly-values-for-graph-report-MGbKBcto.html

Reference NO 8

http://quickfacts.census.gov/gfd/states/00000.html