Click here to Skip to main content
15,881,812 members
Search within:


The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

 
FirstPrevNext
GeneralRe: A new definition of efficiency Pin
BillW3317-Jul-12 10:03
professionalBillW3317-Jul-12 10:03 
GeneralRe: A new definition of efficiency Pin
englebart19-Jul-12 2:02
professionalenglebart19-Jul-12 2:02 
GeneralThis guy don't know what margin property in CSS is. Pin
Hiren solanki12-Jul-12 23:08
Hiren solanki12-Jul-12 23:08 
GeneralRe: This guy don't know what margin property in CSS is. Pin
Andrei Straut12-Jul-12 23:46
Andrei Straut12-Jul-12 23:46 
GeneralRe: This guy don't know what margin property in CSS is. Pin
Hiren solanki12-Jul-12 23:58
Hiren solanki12-Jul-12 23:58 
GeneralRe: This guy don't know what margin property in CSS is. Pin
jsc4216-Jul-12 23:03
professionaljsc4216-Jul-12 23:03 
GeneralRe: This guy don't know what margin property in CSS is. Pin
_Amy18-Jul-12 0:15
professional_Amy18-Jul-12 0:15 
GeneralEvolution of a stored proc PinPopular
virang_2112-Jul-12 20:37
virang_2112-Jul-12 20:37 
I have few of those in one of the project I am responsible to maintain... and sometimes something goes wrong with the system and I have oh no .. not again moment....I am not saying stored proc are bad but at times it takes you on a wild ride when figuring out what went wrong and itis absolute nightmare to debug...

SQL
-- =============================================                        
-- Author: XXXX                    
-- Create date: <06/07/2009>                        
-- Description: <UPDATE MOrdNo>                        
-- =============================================                        
ALTER PROCEDURE [dbo].[uspUpdateMfgOrdNo]                      
AS                      
                      
BEGIN                      
 DECLARE @Machine_Id varchar(8)                      
 DECLARE @Flt_Locn VARCHAR(8)                      
 DECLARE @Prod_Date datetime                      
 DECLARE @Shift_Id VARCHAR(1)                      
 DECLARE @Item_No varchar(15)                      
 DECLARE @Prod_Qty numeric(9,0)                      
 DECLARE @Tot_Prod_Qty NUMERIC(9,0)                      
 DECLARE @Mh_Mfno varchar(8)                      
 DECLARE @Seq_Id NUMERIC(18,0)                      
 DECLARE @WorkCenter_Id VARCHAR(8)                      
 DECLARE @Facility_Id VARCHAR(8)                      
 DECLARE @Matched_MfNo VARCHAR(8)                      
 DECLARE @Available_Qty NUMERIC(9, 0)                      
 DECLARE @CurrentQty NUMERIC(9, 0)                      
 DECLARE @FilledQty NUMERIC(9, 0)                      
 --DECLARE @UpperLimit_Qty NUMERIC(9, 0)                      
 DECLARE @Cono NUMERIC(9, 0)                      
 DECLARE @Scrap_Qty  NUMERIC(9, 0)                      
 DECLARE @RowCount INT                       
 DECLARE @blFlagMultiMO CHAR(1)                      
 DECLARE @MachHistTemp TABLE(Id INT,Machine_Id VARCHAR(8),Flt_Locn VARCHAR(8),Prod_Date DATETIME,                      
   Shift_Id VARCHAR(1),Item_No VARCHAR(15),Prod_Qty NUMERIC(9,0),Mh_Mfno VARCHAR(8),                      
   Seq_Id NUMERIC(18,0))                      
 DECLARE @ROWCNT INT                      
 DECLARE @CNT  INT                      
                      
                        
 SET @blFlagMultiMO = 'F'                      
                       
 BEGIN TRAN                      
                       
 Branch_One:--DECLARATION OF THE BRANCH LABEL                      
                       
 TRUNCATE TABLE MachHistTemp                      
                      
 INSERT INTO MachHistTemp(Machine_Id,Flt_Locn,Prod_Date,Shift_Id,Item_No,Prod_Qty,Mh_Mfno,Seq_Id)                      
 SELECT Machine_Id,Flt_Locn,Prod_Date,Shift_Id,Item_No,Prod_Qty,Mh_Mfno,Seq_Id FROM MachHist WITh(NOLOCK)                      
 WHERE mh_mfno=-1 or mh_mfno=-2 order by mh_mfno DESC --mh_mfno IS NULL OR                      
                      
 SET @CNT=1                      
 SELECT @ROWCNT=MAX(Id) FROM MachHistTemp                      
                       
 WHILE(@CNT <= @ROWCNT)                      
 BEGIN                      
  SELECT @Machine_Id=Machine_Id,@Flt_Locn=Flt_Locn,@Prod_Date=Prod_Date,        
  @Shift_Id=Shift_Id,@Item_No=Item_No,@Prod_Qty=Prod_Qty, @Mh_Mfno=Mh_Mfno,        
  @Seq_Id=Seq_Id FROM MachHistTemp WHERE Id=@CNT                      
                         
  SET @CurrentQty = @Prod_Qty                      
  SET @Scrap_Qty = 0                      
                        
  -- Start Added IF condition on 4/Nov/2009 as suggested by Manager.                      
  IF (@Mh_Mfno = -2)                      
   BEGIN                      
    SET @Scrap_Qty = @Prod_Qty                      
   END                      
   -- End                      
                      
  SELECT @WorkCenter_Id=[Wc_Id] FROM [dbo].[Machine] WITh(NOLOCK) WHERE [Machine_Id] = @Machine_Id                      
  SELECT @Facility_Id = [Faci_Id] FROM dbo.WorkCenter WITh(NOLOCK) WHERE Wc_ID = @WorkCenter_Id                      
                   
  WHILE (@CurrentQty != 0)                      
   BEGIN                      
    -- Start Added on 21/Oct/2009 as suggested by Manager                      
    IF (@Facility_Id = 'C29') -- WETHERILL PARK                      
     BEGIN                      
      SELECT TOP 1 @Matched_MfNo=[Mhd_MfNo],                             @Available_Qty=ISNULL([Mhd_Orqt], 0) - ISNULL([Mhd_Maqa], 0),                      
      @Cono = [Mhd_Cono]                      
      FROM [dbo].[MOrdHdr] WITh(NOLOCK)                      
      -- has qty available to accomodate has is below upper limit                      
      --Changed the Where Clause on 18/November/2009 as asked by Manager                       
      --WHERE ( (ISNULL([Mhd_Maqa], 0) - ISNULL([Mhd_Scqa], 0)) < ISNULL([Mhd_Orqt], 0) )                         
      WHERE ( (ISNULL([Mhd_Maqa], 0)) < ISNULL([Mhd_Orqt], 0) )                         
      --AND  (ISNULL([Mhd_Maqa], 0) - ISNULL([Mhd_Scqa], 0)) >= 0 --extra check                        
      AND [Mhd_Prno]= @Item_No AND [Mhd_Faci]= @Facility_Id                     
      AND [Mhd_Whst] < 90 ---Added on 02/12/2009                     
      ORDER BY [Mhd_Stdt] ASC, [Mhd_Msti] ASC ,[Mhd_MfNo] ASC                     
     END                      
    ELSE IF (@Facility_Id = 'C59') -- WOOD                  
     BEGIN                      
      SELECT TOP 1 @Matched_MfNo=[Mhd_MfNo],                       
      --Changed the Aval Qty calculation on 18/November/2009 as asked by Manager                      
      --@Available_Qty=ISNULL([Mhd_Orqt], 0) - (ISNULL([Mhd_Maqa], 0) - ISNULL([Mhd_Scqa], 0)),                        
      @Available_Qty=ISNULL([Mhd_Orqt], 0) - ISNULL([Mhd_Maqa], 0),                      
      --@UpperLimit_Qty = ISNULL([Mhd_Orqt], 0),                      
      @Cono = [Mhd_Cono]                      
      FROM [dbo].[MOrdHdr] WITh(NOLOCK)                     
      -- has qty available to accomodate has is below upper limit                      
      --Changed the Where Clause on 18/November/2009 as asked by Manager                       
      --WHERE ( (ISNULL([Mhd_Maqa], 0) - ISNULL([Mhd_Scqa], 0)) < ISNULL([Mhd_Orqt], 0) )                         
      WHERE ( (ISNULL([Mhd_Maqa], 0)) < ISNULL([Mhd_Orqt], 0) )                         
      --AND  (ISNULL([Mhd_Maqa], 0) - ISNULL([Mhd_Scqa], 0)) >= 0 --extra check                        
      AND [Mhd_Prno]= @Item_No AND [Mhd_Faci]= @Facility_Id                      
      AND [Mhd_machine] = @Machine_Id -- Added condition on 21/Oct/2009 as suggested by Manager                     
      AND [Mhd_Whst] < 90 ---Added on 02/12/2009                      
      ORDER BY [Mhd_Stdt] ASC, [Mhd_Msti] ASC,[Mhd_MfNo] ASC                   
              
      Print @@ROWCOUNT              
      --Added on 30/03/2010 as per Manager's email                
      IF(@@ROWCOUNT = 0)                  
       BEGIN                
        SELECT TOP 1 @Matched_MfNo=[Mhd_MfNo],                       
        @Available_Qty=ISNULL([Mhd_Orqt], 0) - ISNULL([Mhd_Maqa], 0),                      
        @Cono = [Mhd_Cono]                      
        FROM [dbo].[MOrdHdr] WITh(NOLOCK)                        
        WHERE ( (ISNULL([Mhd_Maqa], 0)) < ISNULL([Mhd_Orqt], 0) )                         
        AND [Mhd_Prno]= @Item_No AND [Mhd_Faci]= @Facility_Id                      
        AND [Mhd_Whst] < 90                 
        ORDER BY [Mhd_Stdt] ASC, [Mhd_Msti] ASC ,[Mhd_MfNo] ASC                  
                      
          END                     
     ---------------------                
     END                      
    -- End                   
                    
                
    IF (@@ROWCOUNT = 0)                      
     BEGIN                      
      SET @CurrentQty = 0                         
     END                      
    ELSE                      
     BEGIN                      
      SET @CurrentQty = @Available_Qty - @CurrentQty                      
                    
       -- Start Code added on 16/Sept/2009                      
                      
      IF (@CurrentQty < 0)                       
       BEGIN                      
        -- This means that the required qty > available qty                      
        SET @FilledQty = @Available_Qty                      
        SET @CurrentQty = ABS(@CurrentQty)                      
        SET @blFlagMultiMO = 'T'                      
                      
        UPDATE [dbo].[MachHist]                      
        SET Mh_Mfno=@Matched_MfNo,                      
        Prod_Qty=@FilledQty                      
        WHERE [Seq_Id]=@Seq_Id                      
                     
        INSERT INTO [dbo].[MachHist](Machine_Id, Flt_Locn, Prod_Date, Shift_Id,            
        Item_No, Prod_Qty, Flt_Code, Mh_Mfno, Crt_date, Crt_time)                      
        VALUES (@Machine_Id, @Flt_Locn, @Prod_Date, @Shift_Id, @Item_No, @CurrentQty,             
        '', NULL, Getdate(), Getdate())                      
                            
        ---UPDATE MOrdHdr FOR maqa,scqa                      
        UPDATE [dbo].[MOrdHdr]                       
        SET [Mhd_Maqa]=ISNULL([Mhd_Maqa],0) + @FilledQty                      
        ,[Mhd_Scqa] = ISNULL([Mhd_Scqa],0) + @Scrap_Qty                 
        WHERE [Mhd_Mfno]=@Matched_MfNo         
        AND [Mhd_Prno]= @Item_No         
        AND [Mhd_Faci]= @Facility_Id                      
                                   
        -- Update the corresponding TOrdHdr record                      
        IF EXISTS (SELECT 1 FROM [dbo].[TOrdHdr] WITh(NOLOCK)                          
           WHERE [Mhd_cono]=@Cono         
           AND [Faci_id]=@Facility_Id         
           AND [Mhd_mfno]=@Matched_MfNo             
           AND [Mhd_prno]=@Item_No         
           AND [Sfdc_Sts] = 'O') -- Start Added AND condition on 14/Oct/2009 as suggested by Manager                      
         BEGIN                      
          UPDATE [dbo].[TOrdHdr]                       
          SET [Mhd_Maqa] = ISNULL([Mhd_Maqa],0) + @FilledQty                      
          ,[Mhd_Scqa] = ISNULL([Mhd_Scqa],0) + @Scrap_Qty                      
          WHERE [Mhd_cono]=@Cono           
          AND [Faci_id]=@Facility_Id           
          AND [Mhd_mfno]=@Matched_MfNo           
          AND [Mhd_prno]=@Item_No                  
          AND [Sfdc_Sts] = 'O' --Added on 24/Feb/2010                       
         END                       
        ELSE                      
         BEGIN                      
          INSERT INTO [dbo].[TOrdHdr](Mhd_cono, Faci_id, Mhd_mfno, Mhd_prno,           
          Mhd_whst, Mhd_orqt, Mhd_prio, Mhd_maqa,                       
          Mhd_scqa, Mhd_stdt, Mhd_msti, Mhd_fidt, Mhd_mfti,           
          Mhd_type, Mhd_locn, Mhd_rptno, Mhd_machine,Sfdc_Sts,        
          Mhd_Seqs , Mhd_Prap, Mhd_Schs, --Added on 24/06/2010                      
          Mhd_Plgf ) -- Added on  25/06/2010      
          SELECT Mhd_cono, Mhd_Faci, Mhd_mfno, Mhd_prno, Mhd_whst,         
          Mhd_orqt, Mhd_prio, @FilledQty,                       
          @Scrap_Qty, Mhd_stdt, Mhd_msti, Mhd_fidt, Mhd_mfti,          
          Mhd_type, Mhd_locn, Mhd_rptno, Mhd_machine,'O',        
          Mhd_Seqs , Mhd_Prap, Mhd_Schs,Mhd_Plgf                      
          FROM [dbo].[MOrdHdr] WITh(NOLOCK)                        
          WHERE [Mhd_Mfno] = @Matched_MfNo          
          AND [Mhd_Prno]= @Item_No         
          AND [Mhd_Faci]= @Facility_Id                         
         END                      
         -- Update the corresponding MOrdOpr record                      
         IF EXISTS (SELECT 1 FROM [dbo].[MOrdOpr] WITh(NOLOCK)                        
             WHERE [Opr_Cono] = @Cono           
             AND [Opr_Faci] = @Facility_Id           
             AND [Opr_Mfno] = @Matched_MfNo                      
             AND [Opr_Prno] = @Item_No)                      
          BEGIN                      
              UPDATE [dbo].[MOrdOpr]                      
              SET [Opr_Maqa] = ISNULL([Opr_Maqa],0) + @FilledQty                      
              ,[Opr_Scqa] = ISNULL([Opr_Scqa],0) + @Scrap_Qty                      
              WHERE [Opr_Cono] = @Cono         
              AND [Opr_Faci] = @Facility_Id           
              AND [Opr_Mfno] = @Matched_MfNo                      
              AND [Opr_Prno] = @Item_No                      
          END -- If a record in MOrdHdr exists, a corresponding record will exist in MOrdOpr                      
                           
          -- Update the corresponding record in TOrdOpr                      
         IF EXISTS (SELECT 1 FROM [dbo].[TOrdOpr] WITh(NOLOCK)                         
             WHERE [Opr_Cono] = @Cono           
             AND [Faci_id] = @Facility_Id           
             AND [Opr_Mfno] = @Matched_MfNo                      
             AND [Opr_Prno] = @Item_No                      
             AND [Sfdc_Sts] = 'O') -- Start Added AND condition on 14/Oct/2009 as suggested by Manager                      
          BEGIN                      
              UPDATE [dbo].[TOrdOpr]                       
              SET [Opr_Maqa] = ISNULL([Opr_Maqa],0) + @FilledQty                      
              ,[Opr_Scqa] = ISNULL([Opr_Scqa],0) + @Scrap_Qty                      
              WHERE [Opr_Cono] = @Cono         
              AND [Faci_id] = @Facility_Id         
              AND [Opr_Mfno] = @Matched_MfNo                      
              AND [Opr_Prno] = @Item_No           
              AND [Sfdc_Sts] = 'O' --Added on 24/Feb/2010                      
          END                       
         ELSE                      
          BEGIN                      
              INSERT INTO [dbo].[TOrdOpr](Opr_cono, Faci_id,           
              Opr_mfno, Opr_prno, Opr_wost, Opr_opno, Opr_opds, Opr_orqt,                      
              Opr_maqa, Opr_scqa, Opr_stdt, Opr_msti, Opr_wcetre,           
              Opr_subc_cf, Opr_Conto, Opr_rptno,Sfdc_Sts)                      
              SELECT Opr_cono, Opr_Faci, Opr_mfno, Opr_prno, Opr_wost, Opr_opno,         
              Opr_opds, Opr_orqt, @FilledQty, @Scrap_Qty, Opr_stdt, Opr_msti,         
              Opr_wcentre, Opr_subc_cf, Opr_Conto, Opr_rptno,'O'                      
              FROM [dbo].[MOrdOpr] WITh(NOLOCK)                        
              WHERE [Opr_Cono] = @Cono         
              AND [Opr_Faci] = @Facility_Id         
              AND [Opr_Mfno] = @Matched_MfNo                      
              AND [Opr_Prno] = @Item_No                          
          END                      
                          
         SET @CurrentQty = 0 --break out of the loop                      
                             
         GOTO Branch_One                       
                            
   END                       
  ELSE                       
   BEGIN                      
    -- This means that the required qty < available qty                
                       
    IF @blFlagMultiMO = 'T'                      
     BEGIN                      
      SET @FilledQty = ABS(@Available_Qty - @CurrentQty) --Commented on 16/Sept/2009                      
      SET @blFlagMultiMO = 'F'                      
     END                      
    ELSE                      
     SET @FilledQty = ABS(@Prod_Qty) --Uncommented on 16/Sept/2009                      
                    
    -- Start Added IF condition on 4/Nov/2009 as suggested by Manager.                      
    IF (@Mh_Mfno = -2)                      
     BEGIN                      
      SET @Scrap_Qty = @Prod_Qty                      
     END           
    ELSE          
     BEGIN          
      SET @Scrap_Qty = 0          
     END                     
    -- End             
          
          
    UPDATE [dbo].[MachHist]                      
    SET Mh_Mfno=@Matched_MfNo                      
    WHERE [Seq_Id]=@Seq_Id                      
                                
                -- added
    BEGIN  
     IF @Scrap_Qty  > @FilledQty   
      declare @currDate varchar(10)   
      declare @errDesc varchar(100)  
  
      Set @currDate= Convert(VARCHAR(10),GetDate(),103)  
      --Set @errDesc = 'MO: ' + @Matched_MfNo + ' - ' +(@FilledQty) + ' - ' + (@Scrap_Qty)  -- modified by charu on 07122011 as it was causing an error
       Set @errDesc = 'MO: ' + CONVERT(varchar,@Matched_MfNo) + ' - ' + CONVERT(varchar,@FilledQty) + ' - ' +  CONVERT(varchar,@Scrap_Qty)    
      exec uspSaveAPIErr @Facility_Id, @currDate, 'uspUpdateMfgOrdNo', 'err', 'qty error', @errDesc , '10' 

    END  
    ---UPDATE MOrdHdr FOR maqa,scqa                      
    UPDATE [dbo].[MOrdHdr]                       
    SET [Mhd_Maqa]=ISNULL([Mhd_Maqa],0) + @FilledQty                      
    ,[Mhd_Scqa] = ISNULL([Mhd_Scqa],0) + @Scrap_Qty                      
    WHERE [Mhd_Mfno]=@Matched_MfNo         
    AND [Mhd_Prno]= @Item_No         
    AND [Mhd_Faci]= @Facility_Id                      
                                   
    -- Update the corresponding TOrdHdr record                      
    IF EXISTS ( SELECT 1 FROM [dbo].[TOrdHdr] WITh(NOLOCK)                         
        WHERE [Mhd_cono]=@Cono         
        AND [Faci_id]=@Facility_Id           
        AND [Mhd_mfno]=@Matched_MfNo         
        AND [Mhd_prno]=@Item_No                      
        AND [Sfdc_Sts] = 'O') -- Start Added AND condition on 14/Oct/2009 as suggested by Manager                      
     BEGIN                      
        UPDATE [dbo].[TOrdHdr]                       
        SET [Mhd_Maqa] = ISNULL([Mhd_Maqa],0) + @FilledQty                      
        ,[Mhd_Scqa] = ISNULL([Mhd_Scqa],0) + @Scrap_Qty                      
        WHERE [Mhd_cono]=@Cono         
        AND [Faci_id]=@Facility_Id           
        AND [Mhd_mfno]=@Matched_MfNo         
        AND [Mhd_prno]=@Item_No                  
        AND [Sfdc_Sts] = 'O' --Added on 24/Feb/2010                       
     END                       
    ELSE                      
     BEGIN                      
        INSERT INTO [dbo].[TOrdHdr](Mhd_cono, Faci_id, Mhd_mfno,           
        Mhd_prno, Mhd_whst, Mhd_orqt, Mhd_prio, Mhd_maqa,                       
        Mhd_scqa, Mhd_stdt, Mhd_msti, Mhd_fidt, Mhd_mfti, Mhd_type,           
        Mhd_locn, Mhd_rptno, Mhd_machine,Sfdc_Sts,        
        Mhd_Seqs , Mhd_Prap, Mhd_Schs,--Added on 24/06/2010           
      Mhd_Plgf) -- Added on 25/06/2010      
        SELECT Mhd_cono, Mhd_Faci, Mhd_mfno, Mhd_prno, Mhd_whst,           
        Mhd_orqt, Mhd_prio, @FilledQty,                       
        @Scrap_Qty, Mhd_stdt, Mhd_msti, Mhd_fidt, Mhd_mfti,          
        Mhd_type, Mhd_locn, Mhd_rptno, Mhd_machine,'O',        
        Mhd_Seqs , Mhd_Prap, Mhd_Schs,Mhd_Plgf                      
        FROM [dbo].[MOrdHdr] WITh(NOLOCK)                        
        WHERE [Mhd_Mfno] = @Matched_MfNo          
        AND [Mhd_Prno]= @Item_No         
        AND [Mhd_Faci]= @Facility_Id                         
     END                      
    -- Update the corresponding MOrdOpr record                      
    IF EXISTS ( SELECT 1 FROM [dbo].[MOrdOpr] WITh(NOLOCK)                         
       WHERE [Opr_Cono] = @Cono           
       AND [Opr_Faci] = @Facility_Id         
       AND [Opr_Mfno] = @Matched_MfNo                      
       AND [Opr_Prno] = @Item_No)                      
     BEGIN                      
      UPDATE [dbo].[MOrdOpr]                      
      SET [Opr_Maqa] = ISNULL([Opr_Maqa],0) + @FilledQty                      
      ,[Opr_Scqa] = ISNULL([Opr_Scqa],0) + @Scrap_Qty                      
      WHERE [Opr_Cono] = @Cono         
      AND [Opr_Faci] = @Facility_Id         
      AND [Opr_Mfno] = @Matched_MfNo                      
      AND [Opr_Prno] = @Item_No                      
     END -- If a record in MOrdHdr exists, a corresponding record will exist in MOrdOpr                      
                       
    -- Update the corresponding record in TOrdOpr                      
    IF EXISTS (SELECT 1 FROM [dbo].[TOrdOpr] WITh(NOLOCK)                          
        WHERE [Opr_Cono] = @Cono         
        AND [Faci_id] = @Facility_Id           
        AND [Opr_Mfno] = @Matched_MfNo                      
        AND [Opr_Prno] = @Item_No                      
        AND [Sfdc_Sts] = 'O') -- Start Added AND condition on 14/Oct/2009 as suggested by Manager                      
     BEGIN                      
        UPDATE [dbo].[TOrdOpr]                       
        SET [Opr_Maqa] = ISNULL([Opr_Maqa],0) + @FilledQty                      
        ,[Opr_Scqa] = ISNULL([Opr_Scqa],0) + @Scrap_Qty                      
        WHERE [Opr_Cono] = @Cono         
        AND [Faci_id] = @Facility_Id         
        AND [Opr_Mfno] = @Matched_MfNo                      
        AND [Opr_Prno] = @Item_No          
        AND [Sfdc_Sts] = 'O' --Added on 24/Feb/2010                     
     END                       
    ELSE                      
      BEGIN                      
        INSERT INTO [dbo].[TOrdOpr](Opr_cono, Faci_id, Opr_mfno,        
      Opr_prno, Opr_wost, Opr_opno, Opr_opds, Opr_orqt,                      
        Opr_maqa, Opr_scqa, Opr_stdt, Opr_msti, Opr_wcetre, Opr_subc_cf,         
        Opr_Conto, Opr_rptno,Sfdc_Sts)                      
        SELECT Opr_cono, Opr_Faci, Opr_mfno, Opr_prno, Opr_wost, Opr_opno,         
        Opr_opds, Opr_orqt,@FilledQty, @Scrap_Qty, Opr_stdt, Opr_msti,         
        Opr_wcentre, Opr_subc_cf, Opr_Conto, Opr_rptno,'O'                      
        FROM [dbo].[MOrdOpr] WITh(NOLOCK)                        
        WHERE [Opr_Cono] = @Cono         
        AND [Opr_Faci] = @Facility_Id         
        AND [Opr_Mfno] = @Matched_MfNo                      
        AND [Opr_Prno] = @Item_No                          
      END                  
                        
    SET @CurrentQty = 0 --break out of the loop                      
                            
   END                      
      END                       
    END                      
                      
   SET @CNT=@CNT + 1                      
  END--END OF WHILE LOOP                      
 COMMIT TRAN                      
END

Zen and the art of software maintenance : rm -rf *

Math is like love : a simple idea but it can get complicated.
GeneralRe: Evolution of a stored proc Pin
BobJanova12-Jul-12 23:23
BobJanova12-Jul-12 23:23 
GeneralRe: Evolution of a stored proc PinPopular
Mike Winiberg16-Jul-12 20:14
professionalMike Winiberg16-Jul-12 20:14 
GeneralRe: Evolution of a stored proc Pin
AspDotNetDev16-Jul-12 20:45
protectorAspDotNetDev16-Jul-12 20:45 
GeneralRe: Evolution of a stored proc Pin
greldak16-Jul-12 21:43
greldak16-Jul-12 21:43 
GeneralRe: Evolution of a stored proc Pin
Stefan_Lang16-Jul-12 21:55
Stefan_Lang16-Jul-12 21:55 
GeneralRe: Evolution of a stored proc Pin
yiangos16-Jul-12 22:43
professionalyiangos16-Jul-12 22:43 
GeneralRe: Evolution of a stored proc Pin
Jan Holst Jensen217-Jul-12 1:01
Jan Holst Jensen217-Jul-12 1:01 
GeneralRe: Evolution of a stored proc Pin
yiangos17-Jul-12 9:16
professionalyiangos17-Jul-12 9:16 
GeneralRe: Evolution of a stored proc Pin
Florin Jurcovici17-Jul-12 1:31
Florin Jurcovici17-Jul-12 1:31 
GeneralRe: Evolution of a stored proc Pin
Harley L. Pebley17-Jul-12 4:47
Harley L. Pebley17-Jul-12 4:47 
GeneralRe: Evolution of a stored proc Pin
krumia17-Jul-12 20:20
krumia17-Jul-12 20:20 
GeneralWhen to check for null ? Pin
Sasha Laurel10-Jul-12 6:19
Sasha Laurel10-Jul-12 6:19 
GeneralRe: When to check for null ? Pin
Brisingr Aerowing10-Jul-12 13:55
professionalBrisingr Aerowing10-Jul-12 13:55 
GeneralRe: When to check for null ? Pin
Sasha Laurel10-Jul-12 18:59
Sasha Laurel10-Jul-12 18:59 
GeneralRe: When to check for null ? Pin
Brisingr Aerowing11-Jul-12 4:37
professionalBrisingr Aerowing11-Jul-12 4:37 
GeneralRe: When to check for null ? Pin
CDP180210-Jul-12 22:25
CDP180210-Jul-12 22:25 
GeneralRe: When to check for null ? Pin
Julien Villers10-Jul-12 23:24
professionalJulien Villers10-Jul-12 23:24 
Last Visit: 31-Dec-99 18:00     Last Update: 19-Apr-24 13:49Refreshᐊ Prev1...373374375376377378379380381382 Next ᐅ

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise
Privacy
Cookies
Terms of Use
Last Updated 19 Apr 2024
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1