stoere procedure

[yazan_zahi]

--1fst sp CREATE PROCEDURE Ks_Ins_Media_Item @Desc nvarchar(200), @added_date datetime, @Added_by nvarchar(100), @item int output As insert into Ks_Media_Item ([Description],Added_Date,Added_By) values(@Desc,@added_date,@Added_by) set @item = @@identity ============================ --2sd sp CREATE PROCEDURE Ks_Ins_Media_Item_content @Item_No int, @content ntext, @textlength int As insert into Ks_Media_Item_content(Item_no,content,text_length) values(@item_no,@content,@textlength) ======================================== --3rd sp CREATE procedure ks_media_item_full_data @Desc nvarchar(200), @added_date datetime, @Added_by nvarchar(100), @content ntext, @textlength int as declare @ItemNo int execute dbo.Ks_Ins_Media_Item @item output,@Desc, @added_date, @Added_by execute dbo.Ks_Ins_Media_Item_content @ItemNo output,@content, @textlength =================================== can you help me i want to pass yhe output parameter to 3rd sp becuse 1st the Item_no is identity yes and in 2sd sp identity false how can i do it pls

[Eric Dahlvang]

CREATE PROCEDURE Ks_Ins_Media_Item
@Desc nvarchar(200),
@added_date datetime,
@Added_by nvarchar(100),
@item int output
As
insert into Ks_Media_Item ([Description],Added_Date,Added_By)
values(@Desc,@added_date,@Added_by)
set @item = @@identity

CREATE PROCEDURE Ks_Ins_Media_Item_content
@Item_No int,
@content ntext,
@textlength int
As
insert into Ks_Media_Item_content(Item_no,content,text_length)
values(@item_no,@content,@textlength)

CREATE procedure ks_media_item_full_data
@Desc nvarchar(200),
@added_date datetime,
@Added_by nvarchar(100),
@content ntext,
@textlength int
as
declare @ItemNo int
execute dbo.Ks_Ins_Media_Item @Desc, @added_date, @Added_by, @ItemNo output
execute dbo.Ks_Ins_Media_Item_content @ItemNo,@content, @textlength

--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters