if 3 duplicate records, by keeping one original and one
duplicate record, and how to delete remaining 2 duplicates in
sql server 2008
No Answer is Posted For this Question
Be the First to Post Answer
differenc between visual studio 2005,2008 & 2010?
What is %Type,%Rowtype?
3. . Explain the Cache memory? What is the advantage of a processor having more cache memory?
how can we get version of database ?
I want to insert date in the form of yyyy-mm-dd... if any changes happen while inserting date format want to show error meg...any one can solve this..??
what are the difference between C,C++and Java
what is dynamic polymorphism?
what is different betweet class and interface in java?
2 Answers Microsoft, Sun Microsystems,
what is best way to create a Thread class & why?
For C sharp,At the time of software is implemented at client site, is it required that client machine have C sharp(Microsoft Visual Basic) setup?
if 3 duplicate records, by keeping one original and one duplicate record, and how to delete remaining 2 duplicates in sql server 2008
hi all, i need ur help in preparing a sql which performs scd2, i mean i have a scd2 mapping i need a sql which can give me same result as scd2 mapping, SRC table: cust_no, loc 01 abc 02 xyz TGT table: pm_ky cust_no loc current_flag 1 01 abc Y 2 02 xyz Y cust 1 has changed his loc to xyz then it loads into TGT table as below, pm_ky cust_no loc current_flag 1 01 abc N 2 02 xyz Y 3 01 xyz Y i need sql to get the above result, hope got me question, Any suggestion will be appreciate.. thanks, Vinod