HI,
I have the below select query to retrieve data which i need.
'Medicalcondition' for each policies are stored in a test column where i have a stored function [dbo].[getConditions] to extract the 'condition part' from the long text.
If i execute - select [dbo].[getConditions] ('MEDDEC907'),
i willl get 'Mild Asthma' as result.
I want to include this [dbo].[getcondition] function in select query to retrieve corresponding medical condition for each policynumber. How to include this in select query to retrieve condition for each policynumber.
Any help will be highly appreciated.
SELECT
MedicalScreening.PolicyNumber
,Traveller.Title
,Traveller.FirstName
,Traveller.LastName
,Traveller.Age
,MedicalScreening.MedicalScore
from MedicalScreening
inner join Traveller
on Traveller.TravellerId = MedicalScreening.TravellerId
Thank You
Regards,
SG