PROCEDURE FOR BINERY CALCULATION IN MSSQLSERVER 2012

--SAMPLE PROCEDURE TO CALCULATE TEAM MANPOWER IN LEFT AND RIGHT

ALTER PROCEDURE [TEAM_POINT]

      @M_ID NVARCHAR(MAX),

      @BV AS NUMERIC

AS

BEGIN

     

      DECLARE @C_ID NVARCHAR(MAX)

      DECLARE @SP_ID NVARCHAR(MAX)

      DECLARE @POS NVARCHAR(MAX)

      DECLARE @XX NVARCHAR(MAX)

      DECLARE @C_ID1 NVARCHAR(MAX)

      DECLARE @SP_ID1 NVARCHAR(MAX)

      DECLARE @POS1 NVARCHAR(MAX)

      DECLARE @I INTEGER

      DECLARE @J INTEGER

     

      SET @XX=@M_ID

      SET @I=0

      WHILE @I=0

      BEGIN

     

            SELECT @C_ID=C_ID,@SP_ID=SP_ID,@POS=POSITION FROM CUST_MAST WHERE C_ID=@XX

            IF @POS='LEFT'

            BEGIN

                  UPDATE POINT_MAST SET NEW_LEFT=NEW_LEFT+@BV WHERE C_ID=@SP_ID

            END

           

            IF @POS='RIGHT'

            BEGIN

                  UPDATE POINT_MAST SET NEW_RIGHT=NEW_RIGHT+@BV WHERE C_ID=@SP_ID

            END

            SET @XX=@SP_ID

            IF LEN(@SP_ID)<3

            BEGIN

                  SET @XX=''

                  SET @I=1

            END

      END

END