Hello, I've got a bit of an unusual request, I want to create some duplicate rows in a SQL Server table ... I look for pertains to removing duplicates, not creating them.<BR><BR>Anyone run ...

It looks something like the following: SELECT b.Id, COUNT(DISTINCT a.UserId ... is basically a pointer to the row number of the results. To do this in MS SQL Server, add the following to the ...

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site.