Yes and you will join the update with the contactid (you have to add the contactid on the select of the CTE)

I think this will do the job

If still slow...

Ok.

I think the join key was not correct on the CTE.

What does this query returns ?

SELECT cb.fullname, STUFF(

(SELECT '; ' + lb.ListName

FROM xxx.dbo.ListMemberBase lmb

INNER JOIN xxx.dbo.ListBase lb ON lb.listid...

Can you post sample lines for each table please ?

Is ListBase a 1-N relation to ListMemberBase?

How do you connect to your final table ?

And with this :

(ISNULL(FieldValue) OR (DT_WSTR,50) (TRIM(FieldValue))) == "" ? (DT_I4) 0 : (DT_I4)...

Maybe you have to invert b and c position ?

I see that the c table appears to be the base table :

WITH CTE_Concat AS (

SELECT c.ListID,t.EntityID, STUFF(

(SELECT '; ' +...

Ok.

sorry I effectively did not understand your problem

I apologize

Can you post your query please ?

I want to see how you display data.

Can you solve your problem by using the ranking...

Hi,

You can join only on table valued

Your expression is not correct you forgot the .value at the end of Fields!FieldName.Value

But as you are now the join will not work

What you...

Ok.

Can you tell me if you page break follow a specific rule ?

you said first page show rows from 1 to 17

then page 2 shows rows 18 to 30

and...

what is the error message ?

maybe you also have to handle NULL Values ?

ok

did you try the expression with "?"

FieldValue == "" ? (DT_I4) 0 : (DT_I4) FieldValue

Hi

What is the expression on your derived column transformation ?

Maybe it is better to use the Convert transformation ?

If it does not work you can handle blank value with the...

Hi

I think you will have no choice but to convert your nvarchar(max) to a compatible format

But what you can do to take 100% of the cases, is to determine the...

Hi

Maybe you can try to split your query and use a cte ?

for example:

WITH CTE_Concat AS (

SELECT b.ListID,b.EntityID, STUFF(

(SELECT '; ' + c.ListName

FROM [server].[xxxxx_MSCRM].[dbo].ListBase c with (nowait)

WHERE b.ListID =...

lskidgel (7/29/2015)

---

I need to display a specific row number for each page; #1-17 on page 1, 18-30 on page 2 etc.

My matrix column grouping include 4 sections; 'week 1', 'week...

Hi

did you put the option ShowColumnAs = Pareto on the Custom Attributes ?