Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 sql server error

Author  Topic 

hichamtanger
Starting Member

2 Posts

Posted - 2014-04-30 : 06:13:31
i have thise error wen i execute procedure stocke
-----------------------------------------------
[Microsoft][ODBC SQL Server Driver][SQL Server]Trop d'arguments sont spécifiés pour la procédure ou la fonction csdcalculeta28


voici le fichier :
-------------------
(800)
-- Drop Table #ETATDATA
Create Table #ETATDATA
(Champ1 datetime ,Champ2 Varchar(20),Champ3 Varchar(30),Champ4 Varchar(40),Champ6 Varchar(50),Champ7 Varchar(60),Champ8 datetime ,Champ9 Varchar(80))

Insert into #ETATDATA(Champ1,Champ2,Champ3,Champ4,Champ6,Champ7,Champ8,Champ9)
Select Distinct TGPCPTCM.DATES as Champ1,TGPCPTCM.HEURE as Champ2,TGPPER.P_MAT as Champ3,TGPPER.P_CODBAD as Champ4,TGPPER.P_NOM as Champ6,TGPPER.P_PRE as Champ7,TGPPER.DATET as Champ8,TGPPER.HEURET as Champ9
From TGPPER
Where TGPPER.P_MAT BETWEEN @Critere_0_0_1 and @Critere_0_0_2
and (P_MAT in (Select P_MAT from #PERSON))

Set @ChaineExec='Select * from #ETATDATA '
if @ChaineSelect is NOT NULL Set @ChaineExec=@ChaineExec+' Where ' +@ChaineSelect
if @ChampOrdre is NOT NULL Set @ChaineExec=@ChaineExec+' Order by '+@ChampOrdre
Exec (@ChaineExec)

GO

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-04-30 : 12:03:41
Could you translate the error for us?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -