Something like the attached.

But not with SQL Server,...

Sounds like you dealt with the symptom but failed to identify and resolve the problem.

What affect did removing the databases from your AG have on your system(s) and processes?

Isn't it interesting how people think some things are bugs instead of not doing things right?

Anything to do with not wanting to write "dbo." any...

Sort of like reading War and Peace, it will take...

Welcome aboard!

Of course, since MS uses sysname as the data type for name in the system views like sys.tables, sys.columns, sys.objects, etc. I would use sysname as the data type for...

Run this after running the first 8 steps you posted earlier and show us the results. There are no conversions from character to data/time occurring so there should be...

If you are using the exact same code in multiple procedures I'd look at seeing if I could change the procedures to call a common procedure where needed rather than...

SQLServerRookie (9/2/2015)

---

Thanks for the replies. Looking at the suggestions given I end up with this query:

SELECT CUSTOMER, MONTH(DATEADD(DAY,DATE,'2004/07/01'))AS MONTH, YEAR(DATEADD(DAY, DATE,'2004/07/01'))AS YEAR, SUM (SALESAMOUNT) AS SALES

FROM MY_TABLE

GROUP BY MONTH(DATEADD(day,CDC,'2004/07/01')),...

You could also try this, just need to add the additional columns you need from the Contacts table.

SELECT

con.ContactId,

COUNT(DISTINCT(pln.PlanId)) OVER (PARTITION BY con.ContactId,...

I would do something like this:

with basedata as (

select

Customer,

dateadd(day,[Date],'20040630') SalesDate,

Sales

from

dbo.YourTable

)

select

Customer,

...

Taking a guess I would say this:

declare @CurDate date = getdate();

select

dateadd(week, datediff(week, 0, @CurDate) - 2, 0),

dateadd(day, 6, dateadd(week, datediff(week, 0, @CurDate)...

Based on what?