SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 sql server error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hichamtanger
Starting Member

Morocco
2 Posts

Posted - 04/30/2014 :  06:13:31  Show Profile  Reply with Quote
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

USA
37157 Posts

Posted - 04/30/2014 :  12:03:41  Show Profile  Visit tkizer's Homepage  Reply with Quote
Could you translate the error for us?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000