Is it possible to set datefirst for a database or server?
I have a week number function on two servers but one sql server returns an incorrect week number and the other one returns correct week number...
Has it something to do with the @@DATEFIRST setting; if so; how can I change that?
(Do not want to use SET DATEFIRST in my function.)
When I run SELECT @@DATEFIRST on the two servers I get 1 on the incorrect and 7 on the correct one.