Sorry EveryBody....

Actually i was so tensed that i was not able to understand anything....

once again Sorry.....

I have five Tables as @Site,@SitesSiteType,@SitePowerType,@SiteTypeRenewal and @PowerTypeRenewal

declare @site table

(

SiteId int,

SiteTypeId int,

PowerTypeId int,

LocationId int,

...

i asks the moderator to please delete this post... i think i made a mistake by posting here my problem....

@Lynn Pettis

Wow... what a great job u did... by scaring me.... thats really grate....

i think you have not studied the scenario clearly.... in sqlteam there was similar question but not the same... once again read it carefully then u will get... u can...

Thanks SSChampion... i will follow the instructions u provided.

Thanks.