Call a procedure

[kaleidoscope]

Hello,
Slowly with me plz; I'm new to T-SQL :)
I hope someone can help with this. I created a stored procedure that is meant to generate a table, but when I call it (EXEC procedure_name) nothing happens (i.e.: checked to see if the table was created but couldn't find any).

- The SQL statements in the procedure seem OK (no error messages)
- The procedure doesn't take any parameters

Did I call the procedure correctly?

Zied

[kaleidoscope]

It looks like there is an error in t-sql syntax...
Can anyone see an error here please:

IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'CreateTransitiveClosure'
AND type = 'P')
DROP PROCEDURE CreateTransitiveClosure

GO
CREATE PROCEDURE CreateTransitiveClosure

AS

declare @sql varchar(1000)

select @sql='insert into tClosure SELECT CONCEPTID1, CONCEPTID2, 1 AS steps FROM Relationships where RELATIONSHIPTYPE=3'
execute (@sql)

GO

EXECUTE CreateTransitiveClosure
GO

[code green]

Looks like this is wrong

WHERE name = N'CreateTransitiveClosure' 

Can't have N their

[kaleidoscope]

Actually, it does not appear to be wrong. The Store procedure was indeed created and saved. If I run the script again it does not tell me that the procedure already exists so the problem shouldn't be there. Any help?

[ck9663]

Your sample did not generate a table, the table is already existing. If the table is not existing, your SP would return an error. Check which database you created your SP and which database you created your table. If all is working well, that means there are no relationshiptype = '3' on your Relationships table.

Good Luck!!!

~~ CK

[kaleidoscope]

I feel stupid :) Thx kindly, ck9663, you hit the nail right on the head! Need to create the table first. Cheers, Z