Sound complicated? It's not, as Mary Ann Richardson shows us. SQL Server lets you use one command to quickly create a new table containing a subset of records from a larger table. For example ...

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 ...