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.peru_worldsys_reporte
AS
BEGIN
SET NOCOUNT ON;
select peru_worldsys.nombre as [CONSULTADO],peru_worldsys.FECHA,peru_worldsys_resultado.NOMBRE AS [RESPONDIDO],peru_worldsys_resultado.tax_id from peru_worldsys inner join peru_worldsys_resultado on peru_worldsys_resultado.id = peru_worldsys.id
order by peru_worldsys.fecha asc,[CONSULTADO] asc
END
GO
GO
CREATE OR ALTER PROCEDURE dbo.peru_worldsys_reporte
AS
BEGIN
SET NOCOUNT ON;
select peru_worldsys.nombre as [CONSULTADO],peru_worldsys.FECHA,peru_worldsys_resultado.NOMBRE AS [RESPONDIDO],peru_worldsys_resultado.tax_id from peru_worldsys inner join peru_worldsys_resultado on peru_worldsys_resultado.id = peru_worldsys.id
order by peru_worldsys.fecha asc,[CONSULTADO] asc
END
GO
Depends On
2Used By
No items found