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

Transact-SQL (2000)

Help

Author

Topic

aykara1982
Starting Member

3 Posts

Posted - 2007-06-21 : 04:07: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

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-21 : 04:52:04

[code]IF dbo.urunderimi(@id) = 1
BEGIN
...
END[/code]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources