Thanks!

Still not able to figure out . 🙁

Sorry that's about it . No new requirement .

Thanks!

Is there anyway I can add new columns TextID and NameID for the numeric fields for Text and Names field ?

--Something like the below resultset

SELECT 1 AS ID,...

Thanks .I will try the solution posted by you shortly and would revert back .

It's multiselect SharePoint data that is causing problem.

SELECT 1 AS ID,'BRZ Brazil' AS Texts ,'Name3' AS Names UNION

SELECT 2 as ID,'BRZ Brazil' AS Texts ,'Name1' AS Names UNION

SELECT 2 as ID,'VEN Venezuela' AS Texts ,'Name2' AS Names...

What if there are more than one field where same split needs to be done ?

CREATE TABLE #Split

(

ID INT,

Texts NVARCHAR(100),Names nvarchar(100)

...

I could it get it working ..

SELECT

pr.Title AS ProjectRoot , pr.ID AS ParentID,

wf.Title AS WorkFlow , wf.ID...

Thanks Luis. It work perfectly .

If I have to add another level (Attribute2 and AttributeID2) how can I achieve it ?

I tried adding JOIN #MyTestTable pa2 ON sp.ChildID =...

Thanks!

Not sure what I need to fix and where in environment variables. Can you please elaborate ?