That's what we suspect, but have not been able to confirm it, or track down why

Lynn Pettis (8/25/2015)

---

blake.hartman (8/25/2015)

---

Nevermind, I see the problem

It should be this

DATEADD( ww, DATEDIFF( ww, 0, <dateparam>-1 ), 0 )

I thought I was going crazy, but someone copied the wrong grouping...

We need the actual date for the "week of" rather than the number and that seemed to be the simplest expression to calc that date

Is there an easier way to...

Nevermind, I see the problem

It should be this

DATEADD( ww, DATEDIFF( ww, 0, <dateparam>-1 ), 0 )

I thought I was going crazy, but someone copied the wrong grouping expression and I...

The previous Monday

So for Sunday Aug 23 2015, it should return Monday Aug 16 2015 instead of Monday Aug 24

We have been using that expression to get the "Week of" date based on the Monday of that week. For some reason though, it recently seems to be returning the...

The Timeout for the linked server is set to 0

Once it fails for me, the related SQL job will also fail if it is run. Given 20 minutes or so,...

yes when I run it from query analyzer as a sproc or if I copy the code script and run it as an ad hoc query it takes no more...

We did rebuld the indexes. The problem only seems to be in vb using ADO. The problem with Access Pass-thorugh queries seems to be fixed by switching DSN's to use...