<div>
So, you've successfully retrieved the values from each SharePoint list? &nbsp;If so, what type of data structure do you have them stored in, and in what language? &nbsp;Perhaps it would be easiest if you show us a bit of your code where you retrieve the values from one of the lists.
</div>


So, you've successfully retrieved the values from each SharePoint list?  If so, what type of data structure do you have them stored in, and in what language?  Perhaps it would be easiest if you show us a bit of your code where you retrieve the values from one of the lists.

<div>
<div class="content wysiwyg-content">
Hi, <br />
I need to create a report in SharePoint 2013 , on premises , There is a custom SharePoint list which has username, Manager and Status. say it SPLIst<br />
I have created another SharePoint list as external content type using SQL procedure which returns all all active users. In this second list say DBList I have username and their department.<br />
My requirement is , I need to compare the two lists and whoever is not found in SPList, should be marked as &quot;Not Started&quot;.<br />
<br />
Could you please help me to achieve this?<br />
<br />
Thanks in advance.<br />
Azra
</div>
</div>


Hi, 
I need to create a report in SharePoint 2013 , on premises , There is a custom SharePoint list which has username, Manager and Status. say it SPLIst
I have created another SharePoint list as external content type using SQL procedure which returns all all active users. In this second list say DBList I have username and their department.
My requirement is , I need to compare the two lists and whoever is not found in SPList, should be marked as "Not Started".

Could you please help me to achieve this?

Thanks in advance.
Azra

Compare two SharePoint list to create a report

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.

LINQ Query

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.