Sunday first last in week?

[Stanciu Vlad]

Is there any chance I make the SQL server think Sunday is the last day of the week (not the first day of the next week) with out changing the regional settings? This is messing up the weekly reports queries...

I have no smart signature yet...

[Stanciu Vlad]

Solved my own problem!

SET DATEFIRST 1; -- set's the first day of the week to monday

SET DATEFIRST 7; -- set's the first day of the week to sunday

I have no smart signature yet...