Page 1 of 1

Store procedure Stimulsoft

Posted: Sat Feb 18, 2017 4:55 pm
by camilo0158
The stored procedure was not found 'execute sp_liquidacion_nomina @Periodo, @IdEntidadNomina, @IdVIgencia

Text query:

execute sp_liquidacion_nomina @Periodo, @IdEntidadNomina, @IdVIgencia

Re: Store procedure Stimulsoft

Posted: Sun Feb 19, 2017 6:31 am
by madlen
hello
try with "execute sp_liquidacion_nomina (@Periodo, @IdEntidadNomina, @IdVIgencia)"

Re: Store procedure Stimulsoft

Posted: Sun Feb 19, 2017 12:22 pm
by Alex K.
Hello,

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

Thank you.

Re: Store procedure Stimulsoft

Posted: Mon Feb 20, 2017 1:33 pm
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

Re: Store procedure Stimulsoft

Posted: Tue Feb 21, 2017 8:30 am
by Alex K.
Hello,

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

Thank you.