Thanks Alan. I appreciate your explanation and I agree with you.

It worked when I removed the DECLARE and Set from the query and I am trying to set the parameters...

How to apply the parameter in the first dataset???

This is what I tried.

SELECT * FROM

(SELECT DISTINCT

a.DiseId,

n1.LastName,

n1.FirstName,

n1.MiddleName,

...............................

FROM Table1 a

----------) AS Entity

WHERE Entity.FirstName + ' '...

I was able to remove the error now.

My Query for second Dataset [FullName] is as follows -

select Distinct FirstName + ' ' + lastName AS FullName

from table2

It might...

Yes, it should select rows from CompanyShortName, ContractCountIndicator which has Y and N multi selections and AssignmentCountIndicator which has Y and N multi selections.

I have attached a screenshot of what...