Interview links c#

 https://www.bytehide.com/blog/csharp-advanced-oops-interview-questions-for-10-years-experienced#What_are_the_differences_between_value_types_and_reference_types_in_C_OOP_How_do_these_differences_impact_memory_management_performance_and_coding_practices

When trying to add data from same table

AFINumber	AFIAmount	OriginalAFINumber	OriginalAFIAmount
2024MSVMX00574-OV1	0.00	2024MSVMX00574	NULL
2024MSVMX00575-OV2	0.00	2024MSVMX00575	NULL
2025HSCIN041092-OV4	1111.00	2025HSCIN041092	NULL

Select T.OriginalAFINumber,T.AFIAmount,T.AFINumber,t.OriginalAFIAmount,O.AFINumber,O.AFIAmount

update T

SET T.OriginalAFIAmount = O.AFIAmount

FROM tbl_afiOverrunAmount_dlt T

INNER JOIN tbl_AFIDetails O 

    ON T.OriginalAFINumber = O.AFINumber

WHERE T.OriginalAFIAmount IS NULL;

Copy to new table

Link
If you want to copy data to an existing table (rather than creating a new table), you should use the INSERT INTO SELECT statement.

SELECT column1, column2, column3, ...
INTO destination_table
FROM source_table;

Data Engineering

 http://fa-ewgu-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_2001/job/25668/?utm_medium=career+site&utm_source=job+alert

Chubb data engineer

kidney stone?

 Foods that increase kidney stone risk include those high in oxalates (like spinach, nuts, and chocolate), sodium (processed and fast foods), animal protein (red meat, fish), and added sugars (sodas and sugary drinks). Excessive caffeine, alcohol, and certain phosphorus-rich processed foods can also contribute to stone formation. Limiting these items and focusing on a balanced diet can help reduce the risk. 

What is the first symptom of a kidney stone?

Kidney stones form in the kidneys. Symptoms may start as stones move into the ureters. The ureters are thin tubes that let urine pass from the kidneys to the bladder. Symptoms of kidney stones can include serious pain, upset stomach, vomiting, fever, chills and blood in the urine.

remove duplicates in an sorted array

 

using System;

public class HelloWorld

{

    

    public static void Main(string[] args)

    {

        int[] ar={2,2,3,3,4,6,6};

         Console.WriteLine("Original Array:");

        Console.WriteLine(string.Join(", ", ar)); // comma-separated

        RemoveDuplicates(ar);

        Console.WriteLine("After removing duplicates :");

        Console.WriteLine(string.Join(", ", ar)); // comma-separated

    }

    static void RemoveDuplicates(int[] ar){

       

       int rd=0;

       

       for(int i=1;i<ar.Length;i++){

           if( ar[rd] != ar[i]){

               rd++;

               ar[rd]=ar[i];

           }

          

       }

        // resize array to actual unique count

        

    }

}

reverse an array c#

 // Online C# Editor for free

// Write, Edit and Run your C# code using C# Online Compiler

using System;

public class HelloWorld

{

    public static void Main(string[] args)

    {

        int[] ar={2,4,6,8,10,12,14};

         Console.WriteLine("Original Array:");

        Console.WriteLine(string.Join(", ", ar)); // comma-separated

        reverse(ar);

        Console.WriteLine("Reversed Array:");

        Console.WriteLine(string.Join(", ", ar)); // comma-separated

    }

    static void reverse(int[] ar){

        int i=0,j=ar.Length - 1;

        while(i < j){

            int t= ar[i];

            ar[i]=ar[j];

            ar[j]=t;

            i++;

            j--;

        }

    }

}