Click here to Skip to main content
15,877,711 members

Comments by Malte Klena (Top 2 by date)

Malte Klena 31-Jan-14 12:45pm View    
DECLARE @table TABLE (column1 char(1), column2 int)
INSERT INTO @table VALUES ('a',1)
INSERT INTO @table VALUES ('a',1)
INSERT INTO @table VALUES ('a',2)
INSERT INTO @table VALUES ('b',5)
INSERT INTO @table VALUES ('b',5)
INSERT INTO @table VALUES ('b',4)


SELECT *
FROM @table
WHERE column2 IN
(
SELECT t.column2
FROM @table t
GROUP BY column2
HAVING COUNT(t.column2) > 1
)
ORDER BY 1
Malte Klena 24-Sep-13 8:00am View    
Have you even tried SqlBulkCopy with or without ColumnMappings?
Probably not.
You're more of the nitpicker, who is bothered by single words or phrases.