Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
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
|SQL Express connecting form remote error 26||7||34|
|Sql Query join multiple table and distinct records||7||26|
|How can I get this column in my query?||2||29|
|Date is within the current week in Crystal Reports||2||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!