InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 03:04:03 GMT20http://www.sqlservercentral.com/Forums/Topic1382290-391-1.aspx[quote][b]sri.chithu.selva (11/8/2012)[/b][hr]I have two dates , thats the week start date and end date . And i needs to know what is the week no for current between those dates . Is this possible ?[/quote]What defines a "week number" at your company? For example, are you usig ISO week numbers, SQL week numbers, or some form of special "fiscal week" numbers? Are the start and end dates also the start and end dates of a single full week, a partial week, or do they span multiple weeks?In any case, the best bet here would probably be to build a "Calendar Table". You can find many examples and some usage examples by doing a web search on the term.Thu, 08 Nov 2012 07:29:25 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1382290-391-1.aspx[quote][b]sri.chithu.selva (11/8/2012)[/b][hr]I have two dates , thats the week start date and end date . And i needs to know what is the week no for current between those dates . Is this possible ?[/quote]This explanation is really poor. If you'd like us to spend our time helping you, please explain the problem, with examples where words are not working.Thu, 08 Nov 2012 01:18:38 GMTDavid McKinneyhttp://www.sqlservercentral.com/Forums/Topic1382290-391-1.aspxHave you tried [code="sql"]DATEPART(WW, @Date)?[/code]Refer [url=http://msdn.microsoft.com/en-us/library/ms174420.aspx]DATEPART[/url]Thu, 08 Nov 2012 00:53:12 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1382290-391-1.aspxI have two dates , thats the week start date and end date . And i needs to know what is the week no for current between those dates . Is this possible ?Thu, 08 Nov 2012 00:17:29 GMTsri.chithu.selva