88 How to find duplicate records in sql server using row_number
ฝัง
- เผยแพร่เมื่อ 9 ก.ย. 2024
- 88 How to find duplicate records in sql server using row_number
Download the scripts used in the video from here: drive.google.c...
SQL Server tutorials: • SQL tutorial for begin...
SQL Server Developer Interview questions: • Sql server developer i...
How to find duplicate records in sql server using row_number
how to find duplicate records in sql server table
How to find duplicate records in SQL query?
How to Find Duplicate Records in SQL?
If you have any questions or suggestions please comment on the video or write to me at “aqil33@gmail.com”
In my sql server table i tried to load data using ssis data flow task and stored procedure in both the methods my created date for every rows is same time stamp for all the 50 k records.
I am using constraint in my created column with default value as getdate().
I also i have updated date column there i have no constraints.
In the derived column i am using getdate() to load the data in the stored procedure also i am using getdate() but still updated column value also same for
All the 50 k records
What could be issue?
Have you ever faced this before
Are you getting Updated column value from source ? Can you check the data in source ? And check the mapping in the destination table. Make sure you are correctly mapping the updated column.
@@learnssis no Actually my source is flat file.
I am just using getdate() in my derived column and assigning it to my updatedDate filed.
Yes mapping is correct actually for all my tables I am facing the same issue for createdDate and updated date.
FYIP it's a new database and server and this is our first project.
My 150k records loaded in 75 secs along with Look up from 9M records from edw.
@@maham4062 So if you are using getDate in derived column then mapping it with update date then of course update date will be same for all 50 k records because you are assigning the getdate value to update date column. Are you directly importing data from flat file to sql server table or using a lookup component to check if a record already exists in sql server table or not ?
@@learnssis loading data directly from source file to SQL server table.
Also I am using constraints for createdDate to use getdate() as default there also I am getting the same date for all the 50k records.
How to resolve updatedDate issue?
What should I do instead of the Drived Column transformation?
@@maham4062 What value should be inserted to updatedDate column ?
Sir Made a video on SQL Execution Plan(Estimated and Actual) and how it works practically and also on arrows(which are known as edge)
Yeah will make a video on that as well.
@@learnssis Thank you So Much Sir