Sql query help..

[Sarvapindi]

Sql experts randi va..oka qn

i have a table ..

Table A...   With 1000 records with columns below

id.   Name

this table will be updated everyday...so some records will be deleted or some new records will be inserted. I want to find what are the records thats r inserted and records that r deleted everyday...and load those into another table...

how to do

[AndhraneedSCS]

Write a trigger and convert the inserts and deletes into an insert into the different table. 

 

 

[BetterThief]

1 minute ago, Sarvapindi said:

Sql experts randi va..oka qn

i have a table ..

Table A...   With 1000 records with columns below

id.   Name

this table will be updated everyday...so some records will be deleted or some new records will be inserted. I want to find what are the records thats r inserted and records that r deleted everyday...and load those into another table...

how to do

daily snapshot teesi data ni inko table lo pettu (Table B).. danito Table A data ni compare chesi neeku kavalsina table lo load cheyyi.

 

Once load done delete records from Table B and reload it with Existing Table A data for next iteration.

[Sarvapindi]

Just now, AndhraneedSCS said:

Write a trigger and convert the inserts and deletes into an insert into the different table. 

 

 

Hmm..actually that table gets loaded from a file...

[JollyBoy]

3 minutes ago, Sarvapindi said:

Hmm..actually that table gets loaded from a file...

Both solutions will work

[Sarvapindi]

1 minute ago, BetterThief said:

daily snapshot teesi data ni inko table lo pettu (Table B).. danito Table A data ni compare chesi neeku kavalsina table lo load cheyyi.

 

Once load done delete records from Table B and reload it with Existing Table A data for next iteration.

gud ba..sql steps cheppu jara

[BetterThief]

Just now, Sarvapindi said:

gud ba..sql steps cheppu jara

10ge.. avi kooda rakunte etla vayya..

 

Inka DDL kooda ivvu manale.

[AndhraneedSCS]

It doesn't matter how the table gets populated. 

 

Trigger will fire up on insert/delete/update on your table,. All your trigger will do is populate this data into another table (call it dummy) and identify if it is an insert/update/delete and continue the operation on the main table.

 

Your dummy table . will have all the information you may need and you just have to query it to see what inserts/updates/deletes ran on that table.

 

if this is a mission-critical table that has 100s of transactions per second through out the day, this approach can cause performance bottleneck. Otherwise, it will work just fine.

 

 

[Sarvapindi]

1 minute ago, BetterThief said:

10ge.. avi kooda rakunte etla vayya..

 

Inka DDL kooda ivvu manale.

ave main ba

[Chinna84]

How u r loading file ??

Ssis ??

 

[Sarvapindi]

Just now, Chinna84 said:

How u r loading file ??

Ssis ??

 

Azure datafactory..

[InSearch]

28 minutes ago, Sarvapindi said:

Hmm..actually that table gets loaded from a file...

Aa file ne source ga use chesukovachugaa... for your new table🤡

[Spartan]

CREATE TRIGGER name_table
ON name
AFTER UPDATE,INSERT
AS 
BEGIN
    INSERT INTO name_change_history(
        id,
        old_name,
        new_name,
        date_of_change
        )
    SELECT 
        i.id,
        d.name,
        i.name,
        GETDATE()
    FROM inserted i
    LEFT JOIN deleted d
        ON i.id = d.id
    WHERE i.name != ISNULL(d.name, -1)
END;

 

[ranku_mogudu]

1 hour ago, Sarvapindi said:

Sql experts randi va..oka qn

i have a table ..

Table A...   With 1000 records with columns below

id.   Name

this table will be updated everyday...so some records will be deleted or some new records will be inserted. I want to find what are the records thats r inserted and records that r deleted everyday...and load those into another table...

how to do

trigger

[Katravelli]

2 hours ago, Spartan said:

CREATE TRIGGER name_table
ON name
AFTER UPDATE,INSERT
AS 
BEGIN
    INSERT INTO name_change_history(
        id,
        old_name,
        new_name,
        date_of_change
        )
    SELECT 
        i.id,
        d.name,
        i.name,
        GETDATE()
    FROM inserted i
    LEFT JOIN deleted d
        ON i.id = d.id
    WHERE i.name != ISNULL(d.name, -1)
END;

 

Super bro nuvvu