Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. Alter PROCEDURE [dbo].[PRC_Reajuste]
  2.  
  3. @cAnio Varchar(4)
  4. ,@cMes Varchar(2)
  5. ,@Rut Varchar(12)
  6.  
  7. AS
  8. BEGIN
  9.  
  10. Declare @Fecha Varchar(10) Set @Fecha = Ltrim((@cAnio)) + Ltrim((@cMes))
  11.  
  12. IF OBJECT_ID('dbo.Tmp_1') IS NOT NULL
  13. BEGIN
  14. DROP TABLE dbo.Tmp_1
  15. IF (@@error <> 0)
  16. BEGIN
  17. ROLLBACK TRAN
  18. RETURN
  19. END END
  20.  
  21. Declare @Consulta varchar(800) Set @Consulta = 'Select * into Tmp_1 From [192.168.37.27].coop.dbo.GACPRO_ReajusteCapital_' + @Fecha + ' Where cRut= ' + '''' + @Rut + ''''
  22.  
  23.  
  24.  
  25.  
  26. End
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement