March 24th, 2004, 06:27 AM
|
 |
Contributing User
|
|
Join Date: Feb 2004
Location: Belgium, Antwerp
Posts: 177
Time spent in forums: 24 sec
Reputation Power: 5
|
|
it my be better to use if statements instead
i'll give you a small example from my current db
PHP Code:
CREATE PROCEDURE dbo.sp_Children
@Type_ID bigint
AS
DECLARE @Niveau bigint
SET @Niveau = (SELECT niveau FROM Type WHERE Type_ID = @Type_ID)
IF @Niveau = 1
(SELECT * FROM Type WHERE Niveau = 2)
ELSE IF @Niveau = 2
(SELECT * FROM Type WHERE (Niveau = 3) OR (Niveau = 4))
ELSE IF @Niveau = 3
(SELECT * FROM Type WHERE (Type_ID = @Type_ID) OR (Niveau = 4))
ELSE IF @Niveau = 4
(SELECT * FROM Type WHERE (Type_ID = @Type_ID) OR (Niveau = 5 AND Parent_ID = @Type_ID))
|
ASP Free Forums Sponsor:
storesprocedure variables
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
