|
|
Posted by Plamen Ratchev on 01/25/07 22:02
There seems to be only one error (the second one is a consequence of that
one), see below:
<Josue.Barrios@gmail.com> wrote in message
news:1169760863.784834.307020@m58g2000cwm.googlegroups.com...
> Hi, i'm trying to make a stored procedure and appear this error on the
> code, i hope somebody can help me
>
> SET ANSI_NULLS ON
> GO
> SET QUOTED_IDENTIFIER ON
> GO
> CREATE PROCEDURE factura_detalle_data
> AS
> BEGIN
> SET NOCOUNT ON;
> DECLARE @tipo_documento VARCHAR
> DECLARE @documento NUMERIC
> DECLARE @item NUMERIC
> DECLARE @especialista VARCHAR
> DECLARE @detalle VARCHAR
> DECLARE @actividad NUMERIC
> DECLARE @cantidad NUMERIC
> DECLARE @descuento NUMERIC
> DECLARE @valor NUMERIC
> DECLARE @doc_anterior NUMERIC
> DECLARE @cont_item NUMERIC
> DECLARE facturas CURSOR FOR SELECT Nro_Factura, Cod_Actividad,
> Ced_Especialista, Cantidad, Porc_Descuento, Subtotal FROM
> Detalle_Factura ORDER BY Nro_Factura ASC
>
>
> SET @doc_anterior = 0
> SET @cont_item = 1
>
> OPEN facturas
>
> WHILE(1=1)
> BEGIN
> FETCH NEXT FROM facturas INTO @documento, @actividad, @especialista,
> @cantidad, @descuento, @valor
> IF (@@FETCH_STATUS = -1)
> BREAK
> IF @doc_anterior = @documento
> BEGIN
> INSERT INTO FTC_FACTURA_DETALLE (TIPO_DOCUMENTO, DOCUMENTO, ITEM,
> ESPECIALISTA, DETALLE, ACTIVIDAD, CANTIDAD, DESCUENTO, VALOR) VALUES
> ('FD', @documento, @cont_item, @especialista, ' ', @actividad,
> @cantidad, @descuento, @valor)
> SET @cont_item = @cont_item + 1 *(first error)
> END
>
> IF @doc_anterior <> @documento
> BEGIN
> @cont_item = 1
Here is the issue, you are missing the SET. The line above should be: SET
@cont_item = 1
> INSERT INTO FTC_FACTURA_DETALLE (TIPO_DOCUMENTO, DOCUMENTO, ITEM,
> ESPECIALISTA, DETALLE, ACTIVIDAD, CANTIDAD, DESCUENTO, VALOR) VALUES
> ('FD', @documento, @cont_item, @especialista, ' ', @actividad,
> @cantidad, @descuento, @valor)
> END
> SET @doc_anterior = @documento *(second error)
> END
> CLOSE facturas
> DEALLOCATE facturas
> END
>
> and the errors are:
> Msg 102, Level 15, State 1, Procedure factura_detalle_data, Line 58
> Incorrect syntax near '@cont_item'.
> Msg 102, Level 15, State 1, Procedure factura_detalle_data, Line 65
> Incorrect syntax near 'END'.
>
> Thanks for the help
>
HTH
Plamen Ratchev
http://www.SQLStudio.com
[Back to original message]
|