USE [magazzino]
GO
/****** Oggetto:  Table [dbo].[temp]    Data script: 07/18/2010 18:28:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[temp](
  [id] [int] NULL,
  [prezzo] [decimal](8, 2) NULL,
  [qta] [int] NULL,
  [sconto1] [int] NULL,
  [sconto2] [int] NULL,
  [sconto3] [int] NULL
) ON [PRIMARY]


INSERT INTO [magazzino].[dbo].[temp] ([id] ,[prezzo] ,[qta],[sconto1] ,[sconto2] ,[sconto3])  VALUES
           (1,15,5,0,0,0)
INSERT INTO [magazzino].[dbo].[temp] ([id] ,[prezzo] ,[qta],[sconto1] ,[sconto2] ,[sconto3])  VALUES
           (2,55.50,2,50,0,0)

INSERT INTO [magazzino].[dbo].[temp] ([id] ,[prezzo] ,[qta],[sconto1] ,[sconto2] ,[sconto3])  VALUES
           (3,25,10,30,20,10)