Hi Thanks to all

For my need update will be happen very rare since due to master data.i am going with triggers.

when i try to use CDC

This change...

Yes this is for time begin solution only. As of now we are using for master table only which has, not more than 10000 rows, not for transaction table....

Thanks to all

Hi for my requirement i have to capture the Changed column Name and the Old Value alone. so to completed my task i used Cusor, Dynamic Quey and...

hi

u have specified not use join and also loop but as per my knowledge we have to use either one concept, so i used join try with this

declare @Temp1...

Hi check with this

; with CommonSeperated_Child

as

(

select1 as 'Level',subTypeId,subTypeValue,subparentId,childLevel,

sortOrder,leafFlag,aggregatesSubTypeId,sourceIdentifier,origId,RecId,CONVERT(varchar(Max),subparentId) camasapavalue

from#SAMPLEDATA

WheresubparentId is null

Union all

selectLevel+1,b.subTypeId,b.subTypeValue,b.subparentId,b.childLevel,

b.sortOrder,b.leafFlag,b.aggregatesSubTypeId,b.sourceIdentifier,b.origId,b.RecId,case when CONVERT(varchar(Max),a.camasapavalue) is null then CONVERT(varchar(Max),b.subparentId)

else CONVERT(varchar(Max),b.subparentId) + ','+CONVERT(varchar(Max),a.camasapavalue)end

camasapavalue

fromCommonSeperated_Childa

Join#SAMPLEDATAbon a.subTypeId = b.subparentId

)

select *

fromCommonSeperated_Child a

Wherelevel...