Hi Gila,

I dont know how to put a execution plan in SQL. I have created in Doc and attached.

Regarding UNION ALL, I was advised that Since both Changes and Changes_DupCK...

Hi Gila,

Please check the attached doc containing the table definition and indexes for all the three tables

and advise.

The table "changes" will have millions of data and so is "Changes_DupCk" ....

I have written this query for checking duplicates by matching request no . But its not checking the third inner join for Duplicates, It only checks the first inner join...

Hi Kapil,

Common data means Duplicate Data or Unique data . please explain How to set Flag over it.

Could you please provide an example on this scenario.

Hi Gila,

Thanks VeryMuch,

It works perfectly as expected. Sorry I am very new to SQL (Fresher) . Thats y asked silly questions.

Thanks Very Much 🙂

Sorry for updating again, I didnt see the second page, I thought my post is not updated.

Hi Gila,

Thanks , I found the mistake and its working now

CREATE PROCEDURE sp5

AS

INSERT INTO AccountMock (Accountno,mode,value,customer,contact)

SELECT Accountno,mode,value,customer,contact FROM AccountTemp at

WHERE EXISTS (SELECT 1 FROM AccountMock am where at.Accountno = am.Accountno...

Hi Gila,

Thanks, I have found the mistake, Sorry im troubling for small syntax errors too.

This works fine .

CREATE PROCEDURE sp4

AS

INSERT INTO AccountMock (Accountno,mode,value,customer,contact)

SELECT Accountno,mode,value,customer,contact FROM AccountTemp at

WHERE EXISTS (SELECT 1...

Hi Gila,

Could you please throw some light on this and make this query workable.

Please advise where im making the mistake.

CREATE PROCEDURE sp3

AS

INSERT INTO AccountMock (Accountno,mode,value,customer,contact)

SELECT (Accountno,mode,value,customer,contact) FROM AccountTemp at

WHERE...

Hi Gila,

Im sorry, I am new to SQl that's why posted wrongly.

Here is my Table Creation

CREATE TABLE [dbo].[Account](

[Accountno] [nchar](10) NOT NULL,

[mode] [nchar](25) NULL,

[value] [nchar](25) NULL,

[customer] [nchar](15) NULL,

[contact]...

Hi Gila,

please find the below things,

ex.

Accounttemp

Accountno mode value customer contact

950017 011 ...

Hi Gila,

Please suggest where to put condition in my stored procedure,

Entire Record from AccountTemp has to go into one of the two tables Account and AccountMock based on one condition,...

Hi Jeff,

Sorry for late reply,

Yes. "ChangesFunction_maintabletable" and "ChangesFunction_temptable" will not have duplicate records.

Only "ChangesFuntction_duplicatecheck " table may have duplicates which means that record is already present in either ChangesFunction_maintabletable...

Hi Jeff,

Thanks Very much !!! . I found it, From your query itself I can find the count 🙂

Once again Thanks for you support 😀

Hi Jeff,

Thanks Very Much !

It worked correctly. Please care to explain one last thing. This duplicate check will happen everyweek.

The reason for doing this activity is , to insert...