The Tuesday issue was my fault, I'd got a bracket in the wrong place so I was adding one to the day instead of one to the week!

LutzM (2/3/2011)

---

That's weird. What is the result of the following statement? It should point to Monday of the current week.

SELECT DATEADD(WEEK, DATEDIFF(WEEK, 0, GETDATE()), 0)

SELECT DATEADD(WEEK, DATEDIFF(WEEK, '19000101', GETDATE()), '19000101')

If...

LutzM (1/18/2011)

---

Yes.

Just change GROUP BY DATEADD(DAY, DATEDIFF(DAY, 0, TIMESTAMP), 0) to the range...

Very neat!

Is there a way of grouping by other intervals e.g. a week or a month?

Thanks, I found this post (http://www.sqlservercentral.com/Forums/Topic869737-338-1.aspx) that used APPLY but I couldn't get it working with MAX unless I went via a temp table.

All the tables are in sysarticles and syssubscriptions.  The status column = 2 = Active.  The agents are running and there are commands appearing in MSrepl_commands tables with Article ID's...

Perhaps it should be moved to a higher traffic forum, like Administration.

 

The SP's have to be independent because they are designed to live on different machines hundreds of miles away.  Ultimately they will, I just want an easy way to test...