Answer the question
In order to leave comments, you need to log in
Why don't arithmetic operations work in case in ms sql?
I can't understand why datepart(ww, part_date) - 1 is not being subtracted in the following construction
select
case
when datepart(weekday, part_date) = 1 then datepart(ww, part_date) - 1 else datepart(ww, part_date) as part_week
end
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question