I am looking to determine what week of the year a date falls in.
what I am running into is Sunday appears to be calculated as first day of the week
is there a way I can change this to Monday being first day of the week as we search for transactions on the work week monday to sunday.
right now if i want to search for data 10 wks ago based on beginning and ending dates
ex: 04-25-2011 to 05-01-2011, 05-01-2011 is sunday and is a diff week no than 04-25-2011
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …