Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO [Production].[WorkOrder]
- ([ProductID]
- ,[OrderQty]
- ,[ScrappedQty]
- ,[StartDate]
- ,[EndDate]
- ,[DueDate]
- ,[ScrapReasonID]
- ,[ModifiedDate])
- SELECT TOP 1000
- [ProductID]
- ,[OrderQty]
- ,[ScrappedQty]
- ,GETDATE()
- ,GETDATE() + 10
- ,[DueDate]
- ,[ScrapReasonID]
- ,[ModifiedDate]
- FROM [Production].[WorkOrder]
Add Comment
Please, Sign In to add comment