Stored Procedure with many If Else if statement

In this Stored procedure (called by [this inventory-checking function](http://codereview.stackexchange.com/q/52587/9357)), many if else if statement are used.  How can it be improved?

          IF ( @count = 1 ) 
         (SELECT skumaster.sku AS SKU, 
                         ( skumaster.minimumstock - Count(*) ) AS ReorderQuantity, 
                         'LowInventory'                        AS Description 
                  FROM   skumaster skuMaster 
                         JOIN inventorymaster inventoryMaster 
                           ON skumaster.sku = inventorymaster.sku 
                  GROUP  BY skumaster.sku, 
                            skumaster.minimumstock, 
                            skumaster.name 
                  HAVING Count(*) < skumaster.minimumstock) 
         ELSE IF( @count = 2 ) 
         (SELECT weeklyorderlist.sku AS SKU, 
                         weeklyorderlist.quantity AS ReorderQuantity, 
                         'NoPO'                   AS Description 
                  FROM   weeklyorderlist 
                  WHERE  weeklyorderlist.pocgen = 'true') 
           ELSE IF( @count = 3 ) 
         (SELECT promotionmaster.sku AS SKU, 
                         ( skumaster.minimumstock + skumaster.maximumstock / 2 ) - 
                         flatdiscount.quantityfordiscount AS ReorderQuantity, 
                         'Flat Discount'                  AS descp 
                  FROM   promotionmaster 
                         JOIN flatdiscount 
                           ON promotionmaster.promotiontypeid = 
                              flatdiscount.promotiontypeid 
                         JOIN skumaster 
                           ON promotionmaster.sku = skumaster.sku 
                  WHERE  promotionmaster.enddate > currenttimezone 
                  --Select from Variable discount  
                  UNION 
                  SELECT variablediscount.sku AS SKU, 
                         variablediscount.quantity AS ReorderQuantity, 
                         'Variable Discount'       AS descp 
                  FROM   promotionmaster 
                         JOIN variablediscount 
                           ON promotionmaster.promotiontypeid = 
                              variablediscount.promotiontypeid 
                  WHERE  promotionmaster.enddate > currenttimezone) 
           ELSE IF( @count = 4 ) 
        (SELECT skumaster.sku AS SKU, 
                         ( skumaster.minimumstock - Count(*) ) AS ReorderQuantity, 
                         'LowInventory'                        AS Description 
                  FROM   skumaster skuMaster 
                         JOIN inventorymaster inventoryMaster 
                           ON skumaster.sku = inventorymaster.sku 
                  GROUP  BY skumaster.sku, 
                            skumaster.minimumstock, 
                            skumaster.name 
                  HAVING Count(*) < skumaster.minimumstock 
                  UNION 
                  SELECT weeklyorderlist.sku AS SKU, 
                         weeklyorderlist.quantity AS ReorderQuantity, 
                         'NoPO'                   AS Description 
                  FROM   weeklyorderlist 
                  WHERE  weeklyorderlist.pocgen = 'true') 
        union 
        (SELECT skumaster.sku AS SKU, 
                         ( skumaster.minimumstock - Count(*) ) AS ReorderQuantity, 
                         'LowInventory'                        AS Description 
                  FROM   skumaster skuMaster 
                         JOIN inventorymaster inventoryMaster 
                           ON skumaster.sku = inventorymaster.sku 
                  GROUP  BY skumaster.sku, 
                            skumaster.minimumstock, 
                            skumaster.name 
                  HAVING Count(*) < skumaster.minimumstock 
                  UNION 
                  SELECT promotionmaster.sku AS SKU, 
                         ( skumaster.minimumstock + skumaster.maximumstock / 2 ) - 
                         flatdiscount.quantityfordiscount AS ReorderQuantity, 
                         'Flat Discount'                  AS descp 
                  FROM   promotionmaster 
                         JOIN flatdiscount 
                           ON promotionmaster.promotiontypeid = 
                              flatdiscount.promotiontypeid 
                         JOIN skumaster 
                           ON promotionmaster.sku = skumaster.sku 
                  WHERE  promotionmaster.enddate > currenttimezone 
                  --Select from Variable discount  
                  UNION 
                  SELECT variablediscount.sku AS SKU, 
                         variablediscount.quantity AS ReorderQuantity, 
                         'Variable Discount'       AS descp 
                  FROM   promotionmaster 
                         JOIN variablediscount 
                           ON promotionmaster.promotiontypeid = 
                              variablediscount.promotiontypeid 
                  WHERE  promotionmaster.enddate > currenttimezone) 
           ELSE IF( @count = 5 ) 
        (SELECT skumaster.sku AS SKU, 
                         ( skumaster.minimumstock - Count(*) ) AS ReorderQuantity, 
                         'LowInventory'                        AS Description 
                  FROM   skumaster skuMaster 
                         JOIN inventorymaster inventoryMaster 
                           ON skumaster.sku = inventorymaster.sku 
                  GROUP  BY skumaster.sku, 
                            skumaster.minimumstock, 
                            skumaster.name 
                  HAVING Count(*) < skumaster.minimumstock 
                  UNION 
                  SELECT promotionmaster.sku AS SKU, 
                         ( skumaster.minimumstock + skumaster.maximumstock / 2 ) - 
                         flatdiscount.quantityfordiscount AS ReorderQuantity, 
                         'Flat Discount'                  AS descp 
                  FROM   promotionmaster 
                         JOIN flatdiscount 
                           ON promotionmaster.promotiontypeid = 
                              flatdiscount.promotiontypeid 
                         JOIN skumaster 
                           ON promotionmaster.sku = skumaster.sku 
                  WHERE  promotionmaster.enddate > currenttimezone 
                  --Select from Variable discount  
                  UNION 
                  SELECT variablediscount.sku AS SKU, 
                         variablediscount.quantity AS ReorderQuantity, 
                         'Variable Discount'       AS descp 
                  FROM   promotionmaster 
                         JOIN variablediscount 
                           ON promotionmaster.promotiontypeid = 
                              variablediscount.promotiontypeid 
                  WHERE  promotionmaster.enddate > currenttimezone) z


           ELSE IF( @count = 6 ) 
       --Select from WeeklyOrder 
                 (SELECT weeklyorderlist.sku AS SKU, 
                         weeklyorderlist.quantity AS ReorderQuantity, 
                         'NoPO'                   AS Description 
                  FROM   weeklyorderlist 
                  WHERE  weeklyorderlist.pocgen = 'true' 
                  UNION 
                  SELECT promotionmaster.sku AS SKU, 
                         ( skumaster.minimumstock + skumaster.maximumstock / 2 ) - 
                         flatdiscount.quantityfordiscount AS ReorderQuantity, 
                         'Flat Discount'                  AS descp 
                  FROM   promotionmaster 
                         JOIN flatdiscount 
                           ON promotionmaster.promotiontypeid = 
                              flatdiscount.promotiontypeid 
                         JOIN skumaster 
                           ON promotionmaster.sku = skumaster.sku 
                  WHERE  promotionmaster.enddate > currenttimezone 
                  --Select from Variable discount  
                  UNION 
                  SELECT variablediscount.sku AS SKU, 
                         variablediscount.quantity AS ReorderQuantity, 
                         'Variable Discount'       AS descp 
                  FROM   promotionmaster 
                         JOIN variablediscount 
                           ON promotionmaster.promotiontypeid = 
                              variablediscount.promotiontypeid 
                  WHERE  promotionmaster.enddate > currenttimezone) 

           ELSE IF( @count = 7 ) 
        --Indicate When Inventory Check and PO Check and Promotion Check is checked 

                 --Select the union from all Inventory Check and PO Check and Promotion Check 
                 (SELECT skumaster.sku AS SKU, 
                         ( skumaster.minimumstock - Count(*) ) AS ReorderQuantity, 
                         'LowInventory'                        AS descp 
                  FROM   skumaster skuMaster 
                         JOIN inventorymaster inventoryMaster 
                           ON skumaster.sku = inventorymaster.sku 
                  GROUP  BY skumaster.sku, 
                            skumaster.minimumstock, 
                            skumaster.name 
                  HAVING Count(*) < skumaster.minimumstock 
                  UNION 
                  SELECT weeklyorderlist.sku AS SKU, 
                         weeklyorderlist.quantity AS ReorderQuantity, 
                         'NoPO'                   AS descp 
                  FROM   weeklyorderlist 
                  WHERE  weeklyorderlist.pocgen = 'true' 
                  UNION 
                  SELECT promotionmaster.sku AS SKU, 
                         ( skumaster.minimumstock + skumaster.maximumstock / 2 ) - 
                         flatdiscount.quantityfordiscount AS ReorderQuantity, 
                         'Flat Discount'                  AS descp 
                  FROM   promotionmaster 
                         JOIN flatdiscount 
                           ON promotionmaster.promotiontypeid = 
                              flatdiscount.promotiontypeid 
                         JOIN skumaster 
                           ON promotionmaster.sku = skumaster.sku 
                  WHERE  promotionmaster.enddate > currenttimezone 
                  UNION 
                  SELECT variablediscount.sku AS SKU, 
                         variablediscount.quantity AS ReorderQuantity, 
                         'Variable Discount'       AS descp 
                  FROM   promotionmaster 
                         JOIN variablediscount 
                           ON promotionmaster.promotiontypeid = 
                              variablediscount.promotiontypeid 
                  WHERE  promotionmaster.enddate > currenttimezone)