thank you allen.

MessageId is foreign key in the @vendor and @vendor_custom table. so there is no way that data will be in @vendor table and not in @ message table. i didn't...

Hi Steve,

thanks for the reply and it's not producing my actual result. Since the data exists on the @vendor, we should not pull any data from @vendor_custom. so logically...

thank you scott.

Thanks everyone who tried to help me and Chris M solution worked for me. appreciated your time on this,

Hi Grant,

Thanks for your reply.

Hi Jeff,

Thank you for your detailed explanation and this will be much helpful to me. Appreciated your time on this.

Hi Jeff,

Thank you for your time on this post and could you please elaborate your point. Below are more explanation from my side

Current table records: 0,...

thanks everyone for your time on this post and i could manage in different way. I just took the first created record time and added needed intraval(newdate) and kept in...

Sure, i will explain again.

I have a table and right now i have duplicates on the table. Only way i can clean the duplicates based on id, RecordInsertedDateTime.

The most of...

as like my sample i have 100*1000 records in my table and dense rank puts incremental number. basically i need the query to delete the duplicate records. any help please