Shri,

if the tables are linked and the CASCADE DELETE is set then you only need to
delete form the parent table, sql server will delete the details record from
the child table
see the eg

CREATE TABLE [dbo].[Table1] (
[id] [int] NOT NULL ,
[c] [char] (10) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Table2] (
[idd] [int] NULL ,
[id] [int] NULL ,
[asd] [char] (10) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Table1] ADD
CONSTRAINT [PK_Table1] PRIMARY KEY  CLUSTERED
(
 [id]
)  ON [PRIMARY]
GO

ALTER TABLE [dbo].[Table2] ADD
CONSTRAINT [FK_Table2_Table1] FOREIGN KEY
(
 [id]
) REFERENCES [dbo].[Table1] (
 [id]
) ON DELETE CASCADE
GO

table1

id          c
----------- ----------
1           sdf
2           ddd
3           tyutyu
4           opiop

table2
idd         id          asd
----------- ----------- ----------
1           1           bnbbn
2           1           ytyyy
1           2           xxxxx
5           3           rrr

now if I delete id=2 from table1, the linked record in table2(idd=1 amd
id=2,asd=xxxxx) will also get deleted

delete from table1 where id=2

table1
id          c
----------- ----------
1           sdf
3           tyutyu
4           opiop

table2

idd         id          asd
----------- ----------- ----------
1           1           bnbbn
2           1           ytyyy
5           3           rrr