Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Alter PROCEDURE [dbo].[PRC_Reajuste]
- @cAnio Varchar(4)
- ,@cMes Varchar(2)
- ,@Rut Varchar(12)
- AS
- BEGIN
- Declare @Fecha Varchar(10) Set @Fecha = Ltrim((@cAnio)) + Ltrim((@cMes))
- IF OBJECT_ID('dbo.Tmp_1') IS NOT NULL
- BEGIN
- DROP TABLE dbo.Tmp_1
- IF (@@error <> 0)
- BEGIN
- ROLLBACK TRAN
- RETURN
- END END
- Declare @Consulta varchar(800) Set @Consulta = 'Select * into Tmp_1 From [192.168.37.27].coop.dbo.GACPRO_ReajusteCapital_' + @Fecha + ' Where cRut= ' + '''' + @Rut + ''''
- End
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement