Hi,

It's OK. i've worked it out there is something very weird going on with some code I have inherited. When I strip over stuff out of the WHERE it works.

I...

That's correct.

When I run the command - I get no results in SQL2012. But in 2000 I know there are [INITIALS] that have more than one character - example below...

To anyone interested - all I had to do was the following -

SELECT MAX([WK].[TRASWEEK]) AS Test

FROM

(

...

Ok.

The view is taking what I am pasting and replacing it with MAX('TRASWEEK') AS TRASWEEK

Which means my result is coming out as text 'TRASWEEK'. How do I get it to...

Bit more information as I'm trying to get to the bottom of this -

When I run the following part of the script in "New Query" window - it works.

SELECT...

Thanks. Worked perfectly.

HanShi (9/3/2013)

Because you perform a calcultation with the values out of the COALESCE I suggest you set a numeric value as second parameter instead of...

Thanks

I've cracked it guys.....

SELECT DISTINCTjob.[ref] AS 'Job Ref'

, COALESCE(APP.APPOINT,'0') AS 'Number of Appointments'

, COALESCE(CARDED.Carded,'0') AS 'Number Times Carded'

, COALESCE(APP.APPOINT,'0') - COALESCE(CARDED.Carded,'0') AS 'APP'

...

Thanks Sean. I forgot to remove that.

Thanks Eugene I will do.

Thanks Eugene. I managed to get this working.

In the end my script looked like below -

SELECT DISTINCT

[Client Name]

,SiteName

,SitePostcode

,[Job Ref]

,[Client Ref]

,[Job Priority]

,[Job Status]

,[Reported Date]

,[Created Date]

,[Job Start Date]

,[Job End DateTime]

,[Job...

Ignore me - I think I know what I need to do.....I'll come back if I need more help :-0

Thanks Chris

Chris I really appreciate your help but you have lost me a little.

I have run the script you have kindly supplied and can see it has created something under the...

I now have a date database, but this still doesn't give me the Fiscal week.

How would I when I create the date table make it so that it creates my...