IF @BOOK = 'ALL' BEGIN IF (@Type = 'ALL') THEN BEGIN PRINT 'ALL Skus, ALL Types' END ELSE IF (@Type IN ('ntrReceipt','Trans','SC' ) OR @TYPE2 IN ('ntrTransfe','ntrReceipt','SP') )THEN BEGIN PRINT 'All SKUs, Receipt, Receipt' END ELSE IF (@TYPE = '2') THEN BEGIN PRINT ' All SKU''s, @Type = 2' END END END ELSE ...In the future please enclouse code between < pre> and < /pre> tags (w/o spaces) for readability.