Hi,

Pleasea find the sample data below:

0763111334 2010-10-27 14:31:18.860Filename 2

0763789334 2010-10-27...

Hi,

Thank you very much.

Your advices were helpful in resolving the primary/ foreign key problem

To answer some of the questions,

The TempCustomer table gets truncated every day, and new data...

Hi,

I hope it makes sense now: i need an sp that does the following:

Condition 1: If an entry is duplicated in TempCustomer, insert into ContactAudit table.

Condition 2: If...

Thank you very much. The script works as expected.

Hi,

Sorry about that.

Here is my sample script:

ALTER PROC spAVM_TempCustomer_I

AS

BEGIN

DECLARE @allcount INT,

@CellphoneNo VARCHAR(15),

@Filename VARCHAR(50),

@Count INT,

@ContactID INT

CREATE TABLE #TempCustomer (CellphoneNo varchar(15))

INSERT #TempCustomer

SELECT CellphoneNo FROM TempCustomer

SELECT @allcount = COUNT(*) FROM #TempCustomer

WHILE @allcount >...

Hi,

I need to:

1) Add a new identity field on table TableA. TableA has a composite Primary key

2) Change the clustered primary key to non-clustered

3) Create clustered index on the...

Thank you very much. The last script works perfect.

This doesn't work still. I replaced A an B with my columns, ContactID and Title. When i run the select it returns Contact table which has ContactID and Title columns.

use...

Thank you very much. The advices worked.