Help - SQL Server Forums

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

SQL Server Development (2000)

Help

Author

Topic

aykara1982
Starting Member

3 Posts

Posted - 2007-06-21 : 04:03:08

ALTER FUNCTION dbo.urunderimi
(
@id int
)
RETURNS bit
AS
BEGIN
DECLARE @deri bit

set @deri=(SELECT UrunID
FROM dbo.Urunler
WHERE (UrunTanimi LIKE N'DER%') AND (UrunCode LIKE N'2 %') and (UrunID=@id) )

RETURN @deri
END

I created a function like above. and then created a procedure which used the function as below.But it didn't work. There was nop error message. Can you help me? Where is my mistake?
Thank you.
My email: pappirus19@gmail.com

ALTER PROCEDURE gsatiskategoriekle

(
@id int output

)

AS
SET NOCOUNT ON

RETURN

IF (Select dbo.urunderimi(@id))=1
BEGIN
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'DA')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'DB')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'DC')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'DD')
END

IF (Select dbo.urunderimi(@id))=0
BEGIN
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'A')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'B')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'C')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'D')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'E')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'F')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'G')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'H')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'I')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'J')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'K')
INSERT INTO GenelSFiyatlari (UrunID,FiyatKategorisi) VALUES (@id,'L')
END

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-06-21 : 04:10:27

please avoid cross post. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85367

pbguy
Constraint Violating Yak Guru

319 Posts

Posted - 2007-06-21 : 04:13:36

Taking value from the SQL will be like below....

SELECT @deri = UrunID
FROM dbo.Urunler
WHERE (UrunTanimi LIKE N'DER%') AND (UrunCode LIKE N'2 %') and (UrunID=@id)

--------------------------------------------------
S.Ahamed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources