Joseph Doherty
26ff8d9b4f
Set up repository with legacy .NET Framework 4.8 source (OLD/), new .NET 10 Blazor solution (NEW/), OpenSpec specifications, documentation, and project configuration.
6 lines
254 B
Transact-SQL
Executable File
6 lines
254 B
Transact-SQL
Executable File
CREATE VIEW [dbo].[WorkOrderTotalScrap] AS
|
|
SELECT wos.WorkOrderNumber,
|
|
COALESCE(SUM(wos.ScrappedQuantity), 0) AS TotalScrappedQuantity
|
|
FROM dbo.WorkOrderStep wos
|
|
WHERE wos.StepNumber = ROUND(wos.StepNumber, 0)
|
|
GROUP BY wos.WorkOrderNumber; |