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.