USE [database]  
GO  
/****** Object:  StoredProcedure [dbo].[codici]    Script Date: 03/03/2010 17:52:55 ******/  
SET ANSI_NULLS OFF  
GO  
SET QUOTED_IDENTIFIER OFF  
GO  
ALTER PROCEDURE [dbo].[codici]  
  
@figura varchar(50)   
   
 AS  
 SELECT    
  b.unmisura,  
  b.codice_az,  
  b.codice_prodotto,  
  b.fig,  
  b.on_line  
     
 FROM  
  tabella b  
 WHERE       
  b.fig = @figura  
  and  
  b.on_line='yes'  
    
  order by codice_prodotto  
return