mira te voy a postear el script porque la vdd no tengo blog por el cual subir la imagen y creo que el foro no deja subirlas o si? aqui te va...espero que asi me entiendas...te repito que la idea es que cuando cree el concepto 99 por ejemplo se realice un movimiento de valor 300. Quizas el q se equivoca sea yo
Código SQL:
Ver originalUSE [PAGOS]
GO
/****** Object: Table [dbo].[Concepto] Script Date: 03/03/2015 00:47:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Concepto](
[Codigo] [INT] NOT NULL,
[Descrip] [VARCHAR](MAX) NOT NULL,
[Tipo] [CHAR](1) NULL,
PRIMARY KEY CLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Cargo] Script Date: 03/03/2015 00:47:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cargo](
[Codigo] [INT] NOT NULL,
[Descripcion] [VARCHAR](MAX) NOT NULL,
[Salario] [REAL] NOT NULL,
CONSTRAINT [PK__Cargo__06370DAD0425A276] PRIMARY KEY CLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[Periodo] Script Date: 03/03/2015 00:47:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Periodo](
[Codigo] [INT] NOT NULL,
[Ano] [CHAR](4) NULL,
[Fechaini] [smalldatetime] NOT NULL,
[Fechafin] [smalldatetime] NOT NULL,
PRIMARY KEY CLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: StoredProcedure [dbo].[listadeperiodos] Script Date: 03/03/2015 00:47:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO