December 21, 2009 at 2:29 am
Hmmm My Report is to show next week for example: this week is 52 so I might see 53.
But some of end year is 52 and some of the end year is 53.When of the end year is 53, so mean 52 add 1, and 53 go to next year and show week number is 1. And if the end year is 52 that will be show 1 next year.
Yes it might show 1.
December 21, 2009 at 2:42 am
Hi
In both the cases you want to display 1? If thats the case then whats the problem?
"Keep Trying"
December 21, 2009 at 3:02 am
Hmmm My Report is to show next week for example: this week is 52 so I might see 53.
But some of end year is 52 and some of the end year is 53.When of the end year is 53, so mean 52 add 1, and 53 go to next year and show week number is 1. And if the end year is 52 that will be show 1 next year.
Yes it might show 1.
December 21, 2009 at 3:35 am
You might want to have a look at BOL (BooksOnLine, the SQL Server help system installed together with SQL Server).
Search for CREATE FUNCTION (Transact-SQL) , Example A.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply