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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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
38200 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  
 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.02 seconds. Powered By: Snitz Forums 2000