-- Get RegisrationId values.
Declare @DadId    numeric = (Select REGISTRATIONID from REGISTRATION where SIGNATURE = 'SKFCM_ASPF_Dad_Id')
Declare @SensorId numeric = (Select REGISTRATIONID from REGISTRATION where SIGNATURE = 'SKFCM_ASPF_Sensor')
Declare @MicrologId numeric = (Select REGISTRATIONID from REGISTRATION where SIGNATURE = 'SKFCM_ASDD_MicrologDAD')
Declare @InputmVEU numeric = (Select REGISTRATIONID from REGISTRATION where SIGNATURE = 'SKFCM_ASPF_Input_mVEU')

-- Display results
Select P1.ElementId, P1.FieldId AS DadId, P1.ValueString AS MicrologDadId, P2.FieldId AS SensorId, p2.ValueString AS SensorType
From Point P1 inner join Point P2 ON
   P1.ElementId = P2.ElementId
Where (P1.FieldId = @DadId and P1.ValueString = Cast(@MicrologId as nvarchar(20)))
   and (P2.FieldId = @SensorId and P2.ValueString = 'Manual')

Select *  from Point P inner join REGISTRATION R 
  ON P.FIELDID = R.REGISTRATIONID
Where ElementId in 
(
   Select P1.ElementId
   From Point P1 inner join Point P2 ON
      P1.ElementId = P2.ElementId
   Where (P1.FieldId = @DadId and P1.ValueString = Cast(@MicrologId as nvarchar(20)))
      and (P2.FieldId = @SensorId and P2.ValueString = 'Manual')
)
and FieldId = @InputmVEU

-- Update Point table for Microlog Analyzer points Where sensor type is manual.
Update Point
Set ValueString = '0.0'
Where ElementId in 
(
   Select P1.ElementId
   From Point P1 inner join Point P2 ON
      P1.ElementId = P2.ElementId
   Where (P1.FieldId = @DadId and P1.ValueString = Cast(@MicrologId as nvarchar(20)))
      and (P2.FieldId = @SensorId and P2.ValueString = 'Manual')
)
and FieldId = @InputmVEU