help me with cross apply with derived field

ASHMITP 141

Hi ,

Please kindly help me with cross apply with Facility_MRN as I am ussing the case statement with another field to get it.
Help me with the query.

select
CASE WHEN CLIENT_ID IS NOT NULL AND CLIENT_ID <> '' AND CLIENT_ID <> '0000000000' THEN
VIEW_CLINIC_MAPPING.[Location Facility ID] + '-' + [CLIENT_ID]
ELSE
'AUID' + '-' + [CLIENT_ID]
END as [Facility_MRN]
,convert(varchar(50),rtrim(se_Facility_MRN.masked_fact_mrn)) as masked_Facility_MRN
FROM [dbo].[SE] se
CROSS APPLY tvf_mask_facility_mrn(se.Facility_MRN) as se_qr_facilitymrn

Thanks

LiHongMSFT-4306 25,651 Reputation points

2022-09-27T01:23:57.243+00:00

Hi @ASHMITP
That's too less information on this issue. For this type of question, you help yourself a lot if you post CREATE TABLE statements for your tables, preferably simplified to focus on the actual problem. Together with INSERT statements with sample data and then the desired result given the sample. So that we’ll get a right direction and make some test. Even more so, if you also give a brief description of why you want that particular result.

Best regards,
LiHong
Olaf Helper 43,246 Reputation points

2022-09-27T05:35:44.673+00:00

Please kindly help me with cross apply with Facility_MRN

That's really to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.

What for example do the TVF = "Table Valued Function" return; we can't guess that?
jerryritcey 1 Reputation point

2022-11-11T20:35:27.513+00:00

Three main things we need 1. list of tables, with create statements 2. some test data inserts so we have some sample data 3. what is the goal of what you are trying to do, and how is what you have tried so far not worked.

Share via

help me with cross apply with derived field