<div>
This one works:<br />
DECLARE @date datetime <br />
SET @date = '20090301' <br />
<br />
SELECT CASE WHEN @date NOT BETWEEN DATEADD(day, -DATEPART(dw, (DATEADD(year, DATEDIFF(year, 0, @date) +1, 0))), (DATEADD(year, DATEDIFF(year, 0, @date) +1, 0))) +1 AND DATEADD(year, DATEDIFF(year, 0, @date) +1, 0) -1 THEN DATENAME(week, @date) <br />
ELSE 1 END <br />
<br />
Lior
</div>


This one works:
DECLARE @date datetime
SET @date = '20090301'

SELECT CASE WHEN @date NOT BETWEEN DATEADD(day, -DATEPART(dw, (DATEADD(year, DATEDIFF(year, 0, @date) +1, 0))), (DATEADD(year, DATEDIFF(year, 0, @date) +1, 0))) +1 AND DATEADD(year, DATEDIFF(year, 0, @date) +1, 0) -1 THEN DATENAME(week, @date)
ELSE 1 END

Lior

<div>
HI<br />
<br />
<a href="http://www.sqlteam.com/article/returning-a-week-number-for-any-given-date-and-starting-fiscal-month" rel="ugc">http://www.sqlteam.com/article/returning-a-week-number-for-any-given-date-and-starting-fiscal-month</a>
</div>


HI

http://www.sqlteam.com/article/returning-a-week-number-for-any-given-date-and-starting-fiscal-month [http://www.sqlteam.com/article/returning-a-week-number-for-any-given-date-and-starting-fiscal-month]

<div>
use this<br />
<br />
Dim weekNum As Integer = DatePart(DateInterval.Week<wbr />OfYear, Date.Now, Microsoft.VisualBasic.Firs<wbr />tDayOfWeek<wbr />.Monday)
</div>


use this

Dim weekNum As Integer = DatePart(DateInterval.WeekOfYear, Date.Now, Microsoft.VisualBasic.FirstDayOfWeek.Monday)

<div>
<div class="content wysiwyg-content">
I need to get the week of year into SQL.<br />
Everything I have tried generates runtime or compile errors.<br />
How can I do this: <br />
<br />
I have asp:<br />
<br />
Label2.Text = string of a date of the year<br />
<br />
<br />
SQL: &quot;&nbsp;... DATEPART(wk, CONVERT(datetime,@Label,10<wbr />1) ) &quot;<br />
<br />
&lt;SelectParameters&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;asp:ControlParameter Name=&quot;Label&quot; &nbsp;ControlID=&quot;Label2&quot; &nbsp;PropertyName=&quot;Text&quot; /&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;/SelectParameters&gt;
</div>
</div>


I need to get the week of year into SQL.
Everything I have tried generates runtime or compile errors.
How can I do this: 

I have asp:

Label2.Text = string of a date of the year


SQL: " ... DATEPART(wk, CONVERT(datetime,@Label,101) ) "

<SelectParameters>
               <asp:ControlParameter Name="Label"  ControlID="Label2"  PropertyName="Text" />
               </SelectParameters>

asp: label.text to week of year?

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications