Hello,

Thanks for your feedback. You're the best.

Hi,

Thanks for your response quickly. What if two tables having the same PurchaseDate? This is sample data only, but my actual large data got the same PurchaseDate. I want to...

Hi,

Thanks for your help. Actually, I was not a person to create the table structure. This table share with a lot of developers. So, I could not change the data...

Hello Matt,

Back to your code that you helped me as following:

update T

set T.saleamount=tot.Totsales

from salestable T inner join

(select t1.Id, sum(t1.saleamount) as Totsales from salestable T1 group by t1.id) tot

on t.id=tot.id

I...

Hello all,

I have some questions back on the code that you helped me, Rajesh. Your code have solved my questions on how to filter the duplicated records, but not stored...

Hello Rajesh,

Thanks for your code genius . It works perfectly. I really appreciate it.

Hi,

Thank for your help quickly to solve my question. In fact, I got a data table which need to be updated that way for moving cost. I got multi duplicated...

Hi,

Your sample SQL did not relate to my question at all. Anyway, thank for your attention.

I got the answer from other TSQL for SS2K5. The solution was

SELECT *

FROM CustomerRecords

WHERE SSN IN

...

Based on your TSQL, I used the following query:

SELECT * FROM CustomerRecords

WHERE SSN IN

...