Note Book
Coalesce example :
DECLARE @name VARCHAR(1024)
SELECT @name=COALESCE (@name + ',', '')+name
FROM test
select @name
delete duplicate records:
DELETE
FROM MyTable
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicatevalueColumn1 , DuplicateValueColumn2 ,
DuplicateValueColumn2 )
DECLARE @name VARCHAR(1024)
SELECT @name=COALESCE (@name + ',', '')+name
FROM test
select @name
delete duplicate records:
DELETE
FROM MyTable
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY Duplicatev
DuplicateValue
The team uses the Hootsuite™ engagement platform, which integrates with a cloud-based analytics and visualization platform called Brandwatch™.
ReplyDelete