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 ?
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.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
How to post code problemsHow to post performance problemsForum FAQs