Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
DECLARE @FindDuplicatedRowsInAsIsTableSQL varchar (MAX); SET @FindDuplicatedRowsInAsIsTableSQL = N'SELECT ID ,Name ,COUNT(*) MYCount INTO #temp1 FROM MyTable GROUP BY ID ,Name HAVING COUNT(*)>1' EXECUTE(@FindDuplicatedRowsInAsIsTableSQL) ---Insert Duplicated Rows in AsIs_DupicatedRowsTable DECLARE @InsertDuplicatedRowsIn_AsIsDupicatedRowsTableSQL varchar (MAX); SET @InsertDuplicatedRowsIn_AsIsDupicatedRowsTableSQL = N'INSERT INTO Xtable SELECT * FROM #temp1'; EXECUTE(@InsertDuplicatedRowsIn_AsIsDupicatedRowsTableSQL)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.