Home Forums SQL Server 7,2000 T-SQL Create FInancial week Dynamic based on parameter RE: Create FInancial week Dynamic based on parameter

  • I want to create the fiscal week for the date.In my case the starting month of the fiscal year keep change it depends on user.

    For that i need help. Above static query is to get the fiscal week for that the starting month is 4.

    Instead of that i would like to use a parameter to get month. By using that is should generate week number.