Need help Server: Msg 446, Level 16, State 9

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)

Need help Server: Msg 446, Level 16, State 9

Author

Topic

Stan Sainte-Rose
Starting Member

3 Posts

Posted - 2001-10-15 : 09:14:10

Hello,

I have problem with a stored proc with SQL Server 2000
It works well with IIS5 with Windows 2000 Server, but breaks with IIS4 with
NT4

This is the error report

Server: Msg 446, Level 16, State 9, Procedure sp_caddie, Line 27
Impossible de résoudre le classement en conflit de l'opération equal to.
- Impossible to resolve the order in conflict with Equal to - (I tried to
translate the french part)

I thank u in advance for your help

here's my stored proc

CREATE PROCEDURE sp_caddie
(
@Page int,
@RecsParPage int,
@idtk varchar(50)

)
AS
SET NOCOUNT ON
Create Table #TempCaddie
(
ID int IDENTITY,
tprod Int,
tcde real,
idshop varchar(50)
)

Insert Into #TempCaddie (idshop,tprod,tcde)
Select idshop, TotalProd=Count(*),totalcde=Sum(qtes*punitaire)
From Templig Where idsession=@idtk Group by idshop

Declare @FirstRec int, @LastRec int
Select @FirstRec = (@Page-1) * @RecsParPage
Select @LastRec = (@Page * @RecsParPage +1)

Select id,idshop,tprod,tcde,societes.idmenu, ' the line 27
<---------------------------------
TotalRecords =
(
Select Count(*)
From #TempCaddie TI

),
societes.raison,societes.logoshop
From #TempCaddie,societes
Where ID>@FirstRec and ID<@LastRec
And idsoc=idshop
Set NoCount OFF
GO

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources