Re: eroare procedura stocata !!

adysan — Mon, 12 May 2008 20:41:16 GMT

de mi-ai fi dat si o palma dupa ceafa si nu m-as fi suparat.....merci

Re: eroare procedura stocata !!

B_gd_n[ ]Sahlean — Mon, 12 May 2008 20:38:34 GMT

Problema este de fapt aici:
AND ID_TIP IN (SELECT idtipDown from #rightsDown and idtipDown <> @tip)

adică
from #rightsDown ~~and~~ WHERE idtipDown

eroare procedura stocata !!

adysan — Mon, 12 May 2008 20:28:27 GMT

salut ,

am urmatoarea procedura stocata:

create procedure [dbo].[uspGivePosRights](

@idop [smallint],

@idpos [int],

@tip [int])

AS
BEGIN
declare @idUser smallint;

create table #rightsUp(idtipUp int)

create table #rightsDown(idtipDown int)

insert #rightsUp exec getTipUpNodes @tip

insert #rightsDown exec getTipDownNodes @tip

SELECT 1

from [ZIM].[dbo].[TBLOP_POS_EMP_ASSOC]

where [ID_OP] = @idop

and isnull([ID_POS],-1) = @idpos

and [id_tip] in (select idtipUp from #rightsUp)

BEGIN TRY

--inactivam drepturile date pozitie pe nivele inferioare spre a activa nivelul superior

UPDATE [TBLOP_POS_EMP_ASSOC]

SET END_DATE = GETDATE()

WHERE ID_OP = @IDOP AND END_DATE IS NULL 

AND ID_TIP IN (SELECT idtipDown from #rightsDown and idtipDown <> @tip)


INSERT INTO TBLOP_POS_EMP_ASSOC (ID_OP, ID_POS,ID_TIP, START_DATE)

VALUES(@IDOP, @IDPOS, @TIP, GETDATE());

RETURN 1;

END TRY

BEGIN CATCH

EXECUTE [dbo].[uspLogError]

RETURN -1;

END CATCH;

--END

END
GO
 
la compilare da urmatoarea eroare "

Msg 156, Level 15, State 1, Procedure uspGivePosRights, Line 29
Incorrect syntax near the keyword 'and'."
linia la care da eroarea fiind cea pe fond galben, si chiar nu inteelg de ce...
Multumesc anticipat pt un raspuns

T-SQL

Re: eroare procedura stocata !!

Re: eroare procedura stocata !!

eroare procedura stocata !!