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

SQL views evaluate the data in the tables underlying the view’s definition when they’re queried. So, the benefit of using SQL views is that they always return the latest data.

Creating a database as you've described is a lot of work, and as others have mentioned their might be better alternatives than a relational database. (or at least the typical structure for a ...