Could you elaborate please, Santosh? Post the code, and the error message? Thanks.

[font="Courier New"]DROP TABLE #SOC_CARE_DATA_QUALITY_EXTRACT_ALIAS_DUPS_ONLY

CREATE TABLE #SOC_CARE_DATA_QUALITY_EXTRACT_ALIAS_DUPS_ONLY

([fi pin] INT, Alias VARCHAR(100))

INSERT INTO #SOC_CARE_DATA_QUALITY_EXTRACT_ALIAS_DUPS_ONLY

([fi pin], Alias)

SELECT 118007, 'Sara Jane smith'UNION ALL

SELECT 118007, 'Sarah Smith'UNION ALL  

SELECT 118007, 'Sara Jayne Smith'UNION ALL  

SELECT...

CREATE PROCEDURE [dbo].[MakeNumbersTable]

-- Courtesy of Jeff Moden, SSC

AS

IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[Numbers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

DROP TABLE dbo.Numbers

--===== Create and populate the Tally...

Click on the highlighted...

Can you post the code for the function?

So...does it work?

Here's a tally-table solution which will run fast.

[font="Courier New"]DROP TABLE #Indus

CREATE TABLE #Indus (serial INT, qh11 VARCHAR(255), qh21 VARCHAR(255))

INSERT INTO #Indus (serial, qh11, qh21)

SELECT 1, '234567890',   '45890' UNION ALL              

SELECT 2,...

Richard Hayes (12/19/2008)

---

ORAC from Blake's 7 was surely the most amazing computer ever? It could predict the future, penetrate other computers and even change its own size, all that...

r.hensbergen (12/18/2008)

---

After reading that 5 times, it sure comes through a lot better.. :crazy: Are you happy now with your query though? If not, please post the table structure, sample...

I'm getting confused now between NoMail, which is bit, and Email, which is some kinda string. But whichever, you're trying to match one to...

What is the datatype of the column NoMail in the customer table? If it's bit, then that's the source of your error message.

Do any of the values of EMail not...

Can you help us with a few samples...

Jack Corbett (12/18/2008)

---

Well, I know a little Redneck (I have a mentor in Florida, in NH now so not getting any lessons), and I know a little SQL Server technical...

Jeff Moden (12/18/2008)

---

bnordberg (12/18/2008)

---

The data in this format will allow for contract tracing of MRSA infections. Our statisticians can pipe this through some algorithims in SAS to see if we...

What have you tried so far, ALI?

Thanks for providing the sample data and table creation scripts, top work.