Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
SQL Script
Copy
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*
*/
CREATE OR ALTER PROCEDURE dbo.ai_genera_txt_edictos
AS
BEGIN
SET NOCOUNT ON;
/*
BUENOSAIRES_20240214_.txt
BUENOSAIRES_20240214_4142854.txt
BUENOSAIRES_20240214_4142854.txt.json
*/
SELECT distinct id_fide, fuente,ltrim(rtrim(convert(varchar(max),contenido_archivo))) as contenido_archivo,fecha_publicacion FROM SOCIEDADES_CONSTITUCIONES
WHERE created > getdate()-20 and (documento_soc ='' or documento_soc is NULL) order by fuente
END
GO
GO
/*
*/
CREATE OR ALTER PROCEDURE dbo.ai_genera_txt_edictos
AS
BEGIN
SET NOCOUNT ON;
/*
BUENOSAIRES_20240214_.txt
BUENOSAIRES_20240214_4142854.txt
BUENOSAIRES_20240214_4142854.txt.json
*/
SELECT distinct id_fide, fuente,ltrim(rtrim(convert(varchar(max),contenido_archivo))) as contenido_archivo,fecha_publicacion FROM SOCIEDADES_CONSTITUCIONES
WHERE created > getdate()-20 and (documento_soc ='' or documento_soc is NULL) order by fuente
END
GO
Depends On
1Used By
No items found