That's an Itzik Ben-Gap "Gaps and Islands" query.  Sorry, I don't have time now to fully flesh it out, but someone should come along shortly who can.

What is the underlying table clustered on?  If it's clus on identity, you should seriously consider clustering instead by date first, esp. if you (almost) always look up by date,...

I don't get any syntax errors.  That error must be because of some text/code before or after the main code.

But you will likely get exec errors, since the...

Btw, you might want to seriously consider using "UNION ALL" there rather than UNION.  I think you are going to force a massive sort of all the rows by using...

You're welcome!  I'm very glad it helped.

SELECT DATEADD(DAY, -DATEDIFF(DAY, 0, [Order Date]) % 7, [Order Date]) AS [Week of],
  COUNT(*) AS Count
FROM dbo.your_table_name
GROUP BY DATEADD(DAY, -DATEDIFF(DAY, 0, [Order Date]) %...

You should pre-allocate enough log space to handle the request.  The alter should be much faster if the log does not have to dynamically expand.  You should do the expansion in...

You should only rebuild a 60GB index if and when you have a really, really compelling reason.

I'd suggest specifying "SORT_IN_TEMPDB = ON" for large rebuilds, unless you have...

Great, thanks!  See if something like this is a good start to what you need.
Btw, if the call table is clustered first on StartTime (as it almost certainly should...

If you'd provide some usable sample data -- CREATE TABLE and INSERT statements -- for QueueCallItems, I (and others) can code something up.  Sorry, but I just don't have additional...

SELECT SCHEMA_NAME(t.schema_id) AS schema_name,
    t.name AS table_name,
    c.name AS column_name,
    c.max_length,
    c.is_nullable,
    c.is_computed
FROM sys.columns c
INNER...