Hey hi
you must be calling sp to achieve this task right
so in once sp also you can delete all your tables..
USE [LTXFlow]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[save_Aging]
@Id int,
@dtTime datetime,
@Status varchar(30),
@UpldMstrId int,
@UpdatedBy int
as
begin
if @Id=1
begin
insert into Tbl1(dtTime,[Status],UpdatedBy,UpldMstrId)values(@dtTime,@Status,@UpdatedBy,@UpldMstrId)
insert into Tbl2(.....)
insert into Tbl3()
.
.
.
.
end
end
instead of calling it 15 times for 15 tables you can add 15 insert statement in one sp.