Posting Yak Master
Posted - 07/19/2013 : 09:00:31
| Hi All,
I try to pass a parameter to a function 'dbo.[getConditions]'
select [dbo].[getConditions] ('GALTACS55785') as MedicalCondition, I got the below result
No heart related procedures declared/ Cholesterol
However i try to pass a value from a table like below
SELECT MSpolicy.ScreeningID , dbo.[getConditions](MSPolicy.ScreeningID ) as MedicalCondition
I got the below error
Msg 9400, Level 16, State 1, Line 2
XML parsing: line 1, character 8000, unexpected end of input
How to pass a value from a table to UDF function.
[MSPolicy table has field 'ScreeningID' eg ('GALTACS55785'),i need to pass this Screeningid to the function to get the corresponding condition for all the ID's]
GALTACS55785 No heart related procedures declared/ Cholesterol
Any help will be highly appreciated