CREATE TABLE [dbo].[Rinnovi](
  [CodPT] [int] NOT NULL,
  [CodRinnovo] [int] NOT NULL,
    [DataScadenza] [date] NULL,
  [TipoRinnovo] [nvarchar](50) NULL,
   CONSTRAINT [PK_Rinnovi] PRIMARY KEY CLUSTERED 
(
  [CodPT] ASC,
  [CodRinnovo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

INSERT INTO [Rinnovi]
           ([CodPT]
           ,[CodRinnovo]
           ,[DataScadenza]
           ,[TipoRinnovo])
VALUES
           (1,1,'01/05/2011','test')
GO

INSERT INTO [Rinnovi]
           ([CodPT]
           ,[CodRinnovo]
           ,[DataScadenza]
           ,[TipoRinnovo])
VALUES
           (1,2,'01/05/2012','annuale')
GO

INSERT INTO [Rinnovi]
           ([CodPT]
           ,[CodRinnovo]
           ,[DataScadenza]
           ,[TipoRinnovo])
VALUES
           (2,1,'18/11/2012','test')
GO

INSERT INTO [Rinnovi]
           ([CodPT]
           ,[CodRinnovo]
           ,[DataScadenza]
           ,[TipoRinnovo])
VALUES
           (3,1,'06/06/2010','test')
GO

INSERT INTO [Rinnovi]
           ([CodPT]
           ,[CodRinnovo]
           ,[DataScadenza]
           ,[TipoRinnovo])
VALUES
           (3,2,'06/06/2011','annuale')
GO
INSERT INTO [Rinnovi]
           ([CodPT]
           ,[CodRinnovo]
           ,[DataScadenza]
           ,[TipoRinnovo])
VALUES
           (3,3,'06/06/2012','triennale')
GO