Anthony - The langauge for the instance is already set to British English, as it is on the server that doesn't have the issue.

That is what confused me. I can't...

I'm afraid I need to change it at the instance level if possible.

The SQL code is wrapped in an app I don't have access to.

Thanks for the info.

I can now see that the date format is different. The server with the issue has a format of mdy where as the one that is ok...

Not sure I know enough about the first option you suggested but I'll have a look into it anyway.

Thanks again for the info

Hi Gail,

Thanks for your reply.

I'm going to have to repair it and have the page discarded as it's in simple recovery mode. This isn't a massive issue but I was...

Ok thanks for the info. We use RedGate Monitor but I find it very limiting and sometimes you can't trust the metrics.

V3 looks a lot better but I'm keen to...

Anthony,

I have been looking into creating some kind of DBA dashboard using SSRS so I was curious as to what sort of things you were looking to monitor in the...

Ok I never thought about using a CTE to accomplish this.

Again this looks perfect for what I need. At the moment I only have a couple of reporting periods but...

Ok I seem to be getting correct figures now so thank you LutzM. I just have one last question. At the moment the query returned will be something like the...

Sorry if the data I supplied had a few issues. I did this in about 5 minutes amongst doing a million other things! Next time I'll take more care.

LutzM -...

Sorry about the delay in replying but here is some sample data and the tables with only the fields I'm referencing:

CREATE TABLE #CASES

(

CASEID INT,

IRN CHAR(20),

CASETYPE CHAR(1),

PROPERTYTYPE CHAR(1),

COUNTRYCODE CHAR(2),

CASECATEGORY CHAR(1),

SUBTYPE CHAR(2)

)

INSERT...

I'm little reluctant to post some actual data on here because its pretty sensitive. But here is the definitions of the tables i'm using.

Cases table:

CREATE TABLE [dbo].[CASES](

[CASEID] [int] NOT NULL,

[IRN]...

Here is the query which makes up my view:

SELECT

C.IRN AS [IRN],

C.CASETYPE AS [CASETYPE],

C.PROPERTYTYPE AS [PROPERTYTYPE],

C.CASECATEGORY AS [CATEGORY],

C.COUNTRYCODE AS [COUNTRYCODE],

C.SUBTYPE AS [SUBTYPE],

P.BASIS AS [BASIS],

CE.EVENTDATE AS [-16DATE],

CE1.EVENTDATE AS [-4DATE],

CE2.EVENTDATE AS [-400DATE],

CE3.EVENTDATE AS...

Thanks for your reply.

I see what you mean so I think I may have to thinkabout how I'm doing this. The view I'm querying to get the data has multiple...

Out of interest what did you change?

I think I may have solved this anyway. The user in SQL had a language of British English set. It seems to be working...