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
-- =============================================
-- Author: Leonel Turchetto
-- Create date: 29/05/2017
-- Description: Homonimos de Legales
-- =============================================
CREATE OR ALTER PROCEDURE dbo.backend_homonimos_legales
as
BEGIN
SET NOCOUNT ON;
select id_edicto,nombre_persona,texto,cuit_integrante,provincia_boletin,fecha_boletin,convert(varchar,cast(fecha_boletin as date),103) as fecha_boletin_formateada from edictos inner join padrones on
cuit_integrante = padrones.identificacion
where cuit_sociedad = '' or cuit_sociedad = null
order by fecha_boletin desc
END
GO
GO
-- =============================================
-- Author: Leonel Turchetto
-- Create date: 29/05/2017
-- Description: Homonimos de Legales
-- =============================================
CREATE OR ALTER PROCEDURE dbo.backend_homonimos_legales
as
BEGIN
SET NOCOUNT ON;
select id_edicto,nombre_persona,texto,cuit_integrante,provincia_boletin,fecha_boletin,convert(varchar,cast(fecha_boletin as date),103) as fecha_boletin_formateada from edictos inner join padrones on
cuit_integrante = padrones.identificacion
where cuit_sociedad = '' or cuit_sociedad = null
order by fecha_boletin desc
END
GO
Depends On
2Used By
No items found