any suggestions on how to resolve this?

Thanks

HI,

I have added the update as follows:

WITH CTE_Concat AS

(

SELECT lb.ListID, lmb.EntityID,

STUFF((SELECT '; ' + lb.ListName

FROM ReznickGroup_MSCRM.dbo.ListMemberBase lmb

INNER JOIN ReznickGroup_MSCRM.dbo.ListBase lb ON lb.listid = lmb.listid

WHERE lmb.entityid = cb.contactid

FOR...

You have been very helpful, but sorry I don't know what you mean by "update"

Still throwing an error:

Msg 102, Level 15, State 1, Line 10

Incorrect syntax near ')'.

WITH CTE_Concat AS (

SELECT lb.ListID, lmb.EntityID,

STUFF((SELECT '; ' + lb.ListName

FROM ReznickGroup_MSCRM.dbo.ListMemberBase lmb

INNER JOIN ReznickGroup_MSCRM.dbo.ListBase lb...

This code sends an error: I must have something coded wrong?

Msg 156, Level 15, State 1, Line 11

Incorrect syntax near the keyword 'FROM'.

WITH CTE_Concat AS

SELECT lb.ListID, lmb.EntityID,

STUFF((SELECT ';...

Exactly what I thought I should see. Should I put that in the CTE_Concat code?

Listbase is a N:1 to ListMemberBase

ListMemberBase is connected to the contact table on entityid = contactid

select c.contactid, c.fullname, lb.listname as 'List Base...

The previous post had some examples of what is being pulled:

Here is the actual data that it should pulling

Abe, DeutschNMTC_New Markets Tax Credit Summit Invitee List 2013

Abe, DeutschReal Estate, Commercial...

Thanks its getting better, but I am still seeing multiple contacts with lists repeated over and over

Example:

Abe, Deutsch Real Estate, Commercial Real Estate Alerts and Events Notifications; Real Estate,

Abe, Deutsch...

SSC-Enthusiastic:

This runs very quickly but I get one contacted and one mailing in cte_concat

The second part only adds the ConcatValues value of the mailing to the first contact

Just wanted to thank you...your solution was perfect

Thank you for the quick reply but I need the actual tables not the system tables.

Database = 'xxxCRM'

Example table = accountbase (field = 'modifiedon' or even 'createdon' for each record...