Hello, I've got a bit of an unusual request, I want to create some duplicate rows in a SQL Server table. We have a WorkOrders table that has our customer orders in it. Every order has a WOID ...

table2 AS b ON a.Id = b.Id GROUP BY b.Id, a.OtherId HAVING (COUNT(DISTINCT a.UserId) > 1) Executing this query in SQL returns results such as: In LINQ, I make a simple call to the same view: ...

I'm pretty much a beginner when it comes to SQL Server administration, so I'm kinda in the dark here.<BR><BR>BTW, both servers use SQL Server 2000.