Store procedure Stimulsoft

Stimulsoft Ultimate discussion
Post Reply
camilo0158
Posts: 2
Joined: Sat Feb 18, 2017 4:50 pm

Store procedure Stimulsoft

Post by camilo0158 »

The stored procedure was not found 'execute sp_liquidacion_nomina @Periodo, @IdEntidadNomina, @IdVIgencia

Text query:

execute sp_liquidacion_nomina @Periodo, @IdEntidadNomina, @IdVIgencia
madlen
Posts: 4
Joined: Sun Feb 19, 2017 5:46 am

Re: Store procedure Stimulsoft

Post by madlen »

hello
try with "execute sp_liquidacion_nomina (@Periodo, @IdEntidadNomina, @IdVIgencia)"
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Store procedure Stimulsoft

Post by Alex K. »

Hello,

Please clarify which product, component and which database are you use?

Thank you.
camilo0158
Posts: 2
Joined: Sat Feb 18, 2017 4:50 pm

Re: Store procedure Stimulsoft

Post by camilo0158 »

Aleksey wrote:Hello,

Please clarify which product, component and which database are you use?

Thank you.
In the management studio I execute it so
EXECUTE sp_liquidacion_nomina 1, 1, 47
GO
And everything is going well

USE Nómina;
-- Drop stored procedure if it already exists
IF EXISTS (
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE SPECIFIC_NAME = 'sp_liquidacion_nomina'
)
DROP PROCEDURE sp_liquidacion_nomina
GO

CREATE PROCEDURE sp_liquidacion_nomina
@Periodo int,
@IdEntidadNomina int,
@IdVigencia int
AS
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Store procedure Stimulsoft

Post by Alex K. »

Hello,

Please clarify which product, component and which database are you use?

Thank you.
Post Reply