Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
create procedure sp_mr_geof2(@parent_part varchar(100) ) as DECLARE @STOCK_ID int DECLARE STOCKCHECK CURSOR FOR select STOCK_ID from BomStructure with (NOLOCK), STOCK_MASTER SM where ParentPart = @parent_part and Route = 0 and ERP_STOCK_CODE = Component order by STOCK_ID OPEN STOCKCHECK FETCH NEXT FROM STOCKCHECK INTO @STOCK_ID WHILE @@FETCH_STATUS = 0 BEGIN exec SP_CREATE_PICK_PIECE @STOCK_ID,-1,'AF',0,-1,2,0,1,0,1,0,0,0,44 FETCH NEXT FROM STOCKCHECK INTO @STOCK_ID END CLOSE STOCKCHECK DEALLOCATE STOCKCHECK
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Multi line chart in crystal report with different category and column value||14||49|
|Crystal Report - Charts||4||53|
|SQL parsing XML works but want to do it another way||4||48|
|SQL Server for XML PATH giving wrong results.||6||61|
Join the community of 500,000 technology professionals and ask your questions.