CREATE TABLE [dbo].[TESTATE](
  [Conto] [int] NOT NULL DEFAULT (0),
  [TIPODOC] [varchar](1) NOT NULL DEFAULT ('B'),
  [SERIEDOC] [varchar](1) NOT NULL DEFAULT ('A'),
  [NUMDOC] [int] NOT NULL DEFAULT (0),
  [DATADOC] [datetime] DEFAULT (NULL),
  [TIPOFATT] [varchar](1) DEFAULT (NULL),
  [SERIEFATT] [varchar](1) DEFAULT (NULL),
  [NUMFATT] [int] NOT NULL DEFAULT (0),
  [DATAFATT] [datetime] DEFAULT (NULL))
GO

CREATE TABLE [dbo].[MOVIMENTI](
  [TIPODOC] [varchar](1) NOT NULL DEFAULT ('B'),
  [SERIEDOC] [varchar](1) NOT NULL DEFAULT ('A'),
  [NUMDOC] [int] NOT NULL DEFAULT (0),
  [RIGA] [int] NOT NULL DEFAULT (0))
GO

DELETE FROM MOVIMENTI
GO
DELETE FROM TESTATE
GO

INSERT INTO TESTATE (Conto, TIPODOC, SERIEDOC, NUMDOC, DATADOC, TIPOFATT, SERIEFATT, NUMFATT, DATAFATT)
    VALUES 
    (1000,'I','A',105,'11/05/2007',NULL,NULL,0,NULL)
GO

INSERT INTO TESTATE (Conto, TIPODOC, SERIEDOC, NUMDOC, DATADOC, TIPOFATT, SERIEFATT, NUMFATT, DATAFATT)
    VALUES 
    (1000,'B','A',720,'15/05/2007','D','A',110,'31/05/2007')
GO

INSERT INTO TESTATE (Conto, TIPODOC, SERIEDOC, NUMDOC, DATADOC, TIPOFATT, SERIEFATT, NUMFATT, DATAFATT)
    VALUES 
    (1000,'D','A',110,'31/05/2007',NULL,NULL,0,NULL)
GO

INSERT INTO MOVIMENTI (TIPODOC, SERIEDOC, NUMDOC, RIGA)
    VALUES
    ('I','A',105,1)
GO

INSERT INTO MOVIMENTI (TIPODOC, SERIEDOC, NUMDOC, RIGA)
    VALUES
    ('I','A',105,2)
GO

INSERT INTO MOVIMENTI (TIPODOC, SERIEDOC, NUMDOC, RIGA)
    VALUES
    ('I','A',105,3)
GO

INSERT INTO MOVIMENTI (TIPODOC, SERIEDOC, NUMDOC, RIGA)
    VALUES
    ('B','A',720,1)
GO

INSERT INTO MOVIMENTI (TIPODOC, SERIEDOC, NUMDOC, RIGA)
    VALUES
    ('B','A',720,2)
GO

INSERT INTO MOVIMENTI (TIPODOC, SERIEDOC, NUMDOC, RIGA)
    VALUES
    ('B','A',720,3)
GO