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.

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid