Hi, here goes at posting the definition then. Apologies if its not what is required, not posted defintion before.

Current View

CREATE view [dbo].[CQN12-5i1_Signposts_Smoking_Cessation]

as

SELECT

'CQN12-5i1_Signposts_Smoking_Cessation as [Measure] (Varchar(37),not null)

,'CQUIN_data'...

My previous posts no longer correlate to what i am trying to achieve now, but the concept is the same. I have a calendar table and also a table with...

Thanks guys.....worked like a treat!

Many Thanks to both for your suggestions. I have managed to make it work!

My only question: is there anyway i can include which row it chooses? For example in some...

HI Dwain,

Sorry to be a pain, but i am struggling to make this work and i know its probably quite simple. Here is what i have changed and the results...

Hi Dwain,

I did have a go at your attempt, however if I want to be able to use this on a monthly basis i would have to do the manual...

THanks Jack,

It now runs, but does not pull the zero values i was hoping for. Do i need to join a calendar table on to it?

hi all,

many thanks for your assistance so far. I have created a units table as mentioned called lchs_ref.dbo.FHL_Units. I have tried to replicate what Jack Corbett has suggested but i...

Hi Chris,

I think what the script you have written appears about right to what i am looking for but keep getting this message: Any ideas why?

Msg 4104, Level 16, State...

Hi,

I have attached a file with the relevant columns on. What i am looking to do is lookup the 'name' column in the nhs_costing.dbo.cost_contacts view (called doneby1) and count the...

I need a count on each row rather than a total for the data set.

I have tried the SUM(CASE WHEN C.Contact_Date = MT.[Date of Expense] THEN 1 ELSE 0...