@steve-2 Collins: Actually I need to find rows which satisfy all the conditions mentioned that if any two records from contact have same nationalidnumber, same birthdate, same mobilephone,...

• This reply was modified 1 year, 9 months ago by  piu.scorpio.
• This reply was modified 1 year, 9 months ago by  piu.scorpio.

@scottpletcher: the data types for firstname and emailaddress fields are text. Will count work on them?

@Phil Parkin>

hi tried including it but then Calcs.Age cant be calculated.

CROSS APPLY(Select distinct Birth_year from Company.Customer) calcs
JOIN GroupInfo g
ON calcs.Age
BETWEEN g.StartAge AND g.EndAge
ORDER BY Tally.n DESC;

Hi @SSC Guru

I Just get a list of Distinct birth years from Customer table. So then based on that list I need to further calculate the other values

            
June 7, 2021 at 2:38 pm
            
#3893005

            
            
                                                
        

Yes. I forgot to mention, I have the valid from and to date.

Hi Grant

This is the error I am getting.

TITLE: Microsoft SQL Server Native Client 11.0

------------------------------

Windows logins are not supported in this version of SQL Server.

<hr />

Regards

Priya

The database lies on Azure storage.

Hello!

The issue is solved now. I took Chris's solution as a reference and it solved the problem. Thank you all for your help! 🙂

Regards

Priya

Hi Thom

Yes. I am using sql but couldnt remember the corresponding function for isempty. So asked the question. But with some search i found that i can use nullif() to...

Hi Chris

Thank you for your reply. But I have an issue. Your suggestion works if i the local variable values are null. But in the actual job they come as...