what makes a condition = true? 
looking at your query 6 records from the 01/03/2018 are true (1), and from 02/03/2018 2 are true (1)

so your results...

select Date ,Amount, Location, [Posted Date], [Posted Amount], Camount,Status
from Tablename
where status ='posted' 
and [Posted Amount] - Camount !=0

select Date    ,Amount,    Location,    [Posted Date],    [Posted Amount],    Camount,Status
from Tablename
where status ='posted'

Give this a twirl

with cte
as (
select a.memberid,b.ProgramID,c.ProgramName
from Member a
join MemberProgram b on...

are there any windows out of focus? try hitting alt + tab to see if there are any warnings hidden

it would be easier to help if we knew what the data looked like, can you provide DDL to create representative data?

Try patindex 

where PATINDEX('%[^A-Z]%',LEFT(PAN_NO,5))=0

Hi Lynn

Runnable task count is 0 and active workers are less that current workers. 

What does come up with High CPU is a select statement getting info...

then just add * or column names

bung your query into a CTE and use Row_number() over partition 

With CTE 
as (
select  HdrID , TabName, rown_number() over (partiton by  HdrID , TabName order by HdrID) as RN
from...

Hi Phil

its hosted on a VM and there are various processes running on poor performing server however, the majority are sleeping only a handful are background tasks

Thanks lowell 
the trigger fires after insert or update and is as basic as; insert x from inserted or deleted. I have select, update, insert and delete permissions  on both...

When i disable the trigger i can insert or update both tables no problems when the trigger is on i get this error the  The user does not have...

Cheers Lowell, my insert works perfect now data loaded

cheers for your help