<div>
also want to use Mondays as the first day of the week
</div>


also want to use Mondays as the first day of the week

<div>
I have found the f_table_date function found here:<br />
<a href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519" rel="ugc">http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519</a><br />
<br />
to be extremely powerful and helpful.<br />
<br />
<br />
select * from dbo.F_TABLE_DATE('1/1/2015<wbr />', '1/1/2016')<br />
<br />
you have the start_of_week_starting_mon<wbr />_date as a field and the iso_week_no as a week number.
</div>


I have found the f_table_date function found here:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519 [http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519]

to be extremely powerful and helpful.


select * from dbo.F_TABLE_DATE('1/1/2015', '1/1/2016')

you have the start_of_week_starting_mon_date as a field and the iso_week_no as a week number.

<div>
<div class="content wysiwyg-content">
I am looking for a way to design a query in SQL to &nbsp;compare date ranges based on week#<br />
current years &nbsp;week# range compared to previous year(s) date ranges with the same week# as current period.<br />
<br />
one issue i have seen is some years have 53 weeks?<br />
<br />
any help or guidance would be greatly appreciated
</div>
</div>


I am looking for a way to design a query in SQL to  compare date ranges based on week#
current years  week# range compared to previous year(s) date ranges with the same week# as current period.

one issue i have seen is some years have 53 weeks?

any help or guidance would be greatly appreciated

sql compare date ranges based on week#'s

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.